Library / Tasks & Project Management
Tasks & Project Management
Turn Daily Sheet Records into Google Tasks with OpenAI
When you run it, it extracts yesterday's records from Google Sheets, has OpenAI classify them and creates Google Tasks.
What it does
# Splitinbatches Workflow ## Overview Automated workflow: Splitinbatches Workflow. This workflow integrates 12 different services: stickyNote, httpRequest, googleTasks, merge, set. It contains 22 nodes and follows best practices for error handling and security. ## Workflow Details - Total Nodes: 22 - Node Types: 12 - Error Handling: ✅ Implemented - Security: ✅ Hardened (no sensitive data) - Documentation: ✅ Complete ## Node Breakdown - Loop Over Items: splitInBatches - Merge: merge - If Node: if - Extract Yesterday Records: httpRequest - Sticky Note1: stickyNote - Extract HTML Blocks: html - Parse Blocks: html - Sticky Note: stickyNote - Sticky Note2: stickyNote - Google Tasks: googleTasks - ... and 12 more nodes ## Usage Instructions 1. Configure Credentials: Set up all required API keys and credentials 2. Update Variables: Replace any placeholder values with actual data 3. Test Workflow: Run in test mode to verify functionality 4. Deploy: Activate the workflow for production use ## Security Notes - All sensitive data has been removed or replaced with placeholders - Error handling is implemented for reliability - Follow security best practices when configuring credentials ## Troubleshooting - Check error logs if workflow fails - Verify all credentials are properly configured - Ensure all required services are accessible
The steps
- Loop Over Items
- Merge
- If Node
- Extract Yesterday Records
- Extract HTML Blocks
- Parse Blocks
- Google Tasks
- When clicking ‘Test workflow’
- Classification Agent
- Collect Answer
- Record Sustainability Procedures
- Edit Links
- Error Handler
- Error Handler for b1b1616c
25 steps in total.
Similar automations
Tasks & Project ManagementTurn OMI Voice Memos into Journals and Tasks30 stepsTasks & Project ManagementTurn Starred and Unread Emails into Todoist Tasks21 stepsTasks & Project ManagementTurn Invoice Emails in Gmail into Google Tasks10 stepsTasks & Project ManagementTurn Telegram Meeting Notes into Notion and TickTick Tasks11 steps