Extract tasks from Google Drive screenshots with GPT-4o-mini, Sheets and Slack
Ready for 3.0What this workflow does
This AI workflow has 11 nodes and runs on Google Drive events (file created). Along the way it connects Google Drive, OpenAI, Google Sheets and Slack.
How it runs
Trigger: On Google Drive events (file created).
- Download New Screenshot (Google Drive): download
- AI – Extract Tasks from Screenshot (OpenAI): analyze (image)
- Parse AI Task JSON (Code): runs custom JavaScript code
- Expand Tasks with File Details (Code): runs custom JavaScript code
- Filter Empty Task Titles (If): checks a condition and branches into true / false
- Add Task Row to Sheet (Google Sheets): append
- Fetch All Slack Users (Slack): get many (user)
- Skip Bot Accounts (If): checks a condition and branches into true / false
- Loop Through Human Users (Loop Over Items (Split in Batches)): loops over the items in batches
- Send Slack DM per User (Slack): uses Slack
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- Google Drive Trigger
n8n-nodes-base.googleDriveTrigger - Google Drive
n8n-nodes-base.googleDrive - OpenAI
@n8n/n8n-nodes-langchain.openAi - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - Slack
n8n-nodes-base.slack - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches
From the author
Quick overview This workflow watches a Google Drive folder for new screenshot files, uses OpenAI (GPT-4o-mini) to extract tasks as structured JSON, appends the tasks to Google Sheets, and then sends a Slack direct message to each human user in the workspace.…