Google Sheets → Web Forms Automation with OpenAI, Playwright & Slack

Automate web form completion from Google Sheets changes—using OpenAI, Playwright, and Slack

This n8n workflow listens for updates in Google Sheets, uses OpenAI with a Playwright (MCP) browser to fill a provided web form (without submitting), and then reports screenshots + results to Slack while saving a session video to Cloudinary and updating the originating sheet row.

What this workflow does

• Receives a POST webhook containing the edited Google Sheets row values (action, row number, form URL, instructions, and optional form type).
• Proceeds only if the action equals “Send”.
• If the form URL or instructions are missing, marks the row in Google Sheets as Error.
• Updates the row status to Working and posts a starting message to Slack to create a thread for progress updates.
• Uses OpenAI with a Playwright MCP browser (via Apify) to navigate to the provided URL, follow the instructions, and generate progress updates.
• Sends progress screenshots to the Slack thread, then captures final screenshot and session video URLs.
• Uploads the screenshot to Slack along with the agent’s written report.
• Downloads the session video, uploads it to Cloudinary, posts the Cloudinary link to Slack, and updates the Google Sheets row as Completed with the video URL (or Error if no video is produced).

Use cases

• Operations teams trigger web-form workflows directly from a Google Sheet task list.
• QA and support automate data entry for repeated form-filling tasks while keeping a Slack audit trail.
• SaaS operators manage “request → fill form → verify output” pipelines with row-level status tracking.

Technical details

• n8n nodes / integrations: webhook, if, set, HTTP Request, Slack, Google Sheets.
• Browser automation: Playwright (MCP) via Apify, guided by OpenAI.
• Media handling: screenshot uploads to Slack; session video uploaded to Cloudinary.