Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

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

  1. Loop Over Items
  2. Merge
  3. If Node
  4. Extract Yesterday Records
  5. Extract HTML Blocks
  6. Parse Blocks
  7. Google Tasks
  8. When clicking ‘Test workflow’
  9. Classification Agent
  10. Collect Answer
  11. Record Sustainability Procedures
  12. Edit Links
  13. Error Handler
  14. Error Handler for b1b1616c

25 steps in total.

Similar automations