n8n Workflow: Auto-generate Google Sheets Product Copy w/ Gemini + Slack

Auto-generate Google Sheets product marketing copy with Gemini + Slack (daily, rate-limited)

This n8n workflow scans your Google Sheets Products list every morning, automatically generates SEO product descriptions and meta titles using Google Gemini, writes the results back to the sheet, and posts a completion summary to Slack.

What this workflow does

• Runs on a schedule every day at 06:00 via a Schedule Trigger.
• Reads product rows from Google Sheets that are missing marketing copy (using your selected spreadsheet and the Products sheet).
• Processes items in batches of five to stay within Google Gemini rate limits.
• Generates copy per product by sending product name, features, and target keywords to Google Gemini, producing:
  • a ~60-word description
  • a “META:” SEO meta title line
• Splits Gemini output into separate description and meta title fields (so your sheet columns stay clean).
• Upserts results back into Google Sheets, then—once all batches finish—posts a summary message to Slack.

Use cases

• Keep an e-commerce catalog up to date by filling missing Google Sheets product descriptions without manual copywriting.
• Improve SEO coverage by consistently generating meta titles for products based on features and target keywords.
• Ops-friendly monitoring: receive a daily Slack notification confirming processing completion and batch run status.

Technical details

• n8n nodes / components: Schedule Trigger, Google Sheets (read/write), Split in Batches, Code, Split, Slack, and Sticky Note for workflow documentation.
• Integrations: Google Sheets OAuth2, Google Gemini (PaLM) API credentials, and Slack OAuth2.
• Configuration: Select your spreadsheet + Products tab in both read and write steps, confirm columns like Product Name, Features, Keywords, and the fields for description/meta title, and adjust batch size (default: 5) for your catalog and Gemini rate limits.