n8n Workflow: Extract Tasks from Google Drive Screenshots with GPT-4o-mini

Turn Google Drive screenshots into actionable tasks—automatically

This n8n workflow watches a Google Drive folder for newly added screenshot files, uses OpenAI (GPT-4o-mini) to extract tasks as strict JSON, records them in Google Sheets, and then sends a Slack direct message to each human user in your workspace.

What this workflow does

• Monitors Google Drive: Triggers every minute when a new file is created in a specified folder.
• Processes screenshots with GPT-4o-mini: Downloads the new screenshot and sends it to OpenAI (GPT-4o-mini) to extract tasks in a strict JSON format.
• Builds task items: Parses the response into a tasks array and expands each task into individual entries enriched with the file name, Google Drive link, and a timestamp.
• Prevents junk rows: Filters out any extracted items with an empty task title.
• Appends to Google Sheets: Writes each valid task as a new row including title, description, priority, source link, and timestamp.
• Notifies via Slack: Lists Slack users, filters out bot accounts, and sends a direct message (currently “hiii”) to each remaining user. You can customize the DM text in the setup.

Use cases

• Convert screenshot-based planning notes into a structured task backlog in Google Sheets.
• Automatically capture to-dos from shared Drive folders and immediately notify your team in Slack.
• Operational workflows where screenshots are used as lightweight documentation and need to become trackable tasks.

Technical details

• n8n nodes: if, code, slack, sticky note, Google Drive, Google Sheets.
• OpenAI integration: GPT-4o-mini to extract tasks from screenshot images into strict JSON.
• Slack integration: list users, exclude bot accounts, send direct messages.

Setup checklist

• Connect Google Drive credentials and set the folder ID.
• Add OpenAI credentials with access to gpt-4o-mini.
• Connect Google Sheets and configure the spreadsheet/document ID and sheet tab.
• Connect Slack credentials to list users and send DMs; customize the DM text as needed.