{"product_id":"n8n-workflow-auto-generate-google-sheets-product-copy-w-gemini-slack","title":"n8n Workflow: Auto-generate Google Sheets Product Copy w\/ Gemini + Slack","description":"\u003ch3\u003eAuto-generate Google Sheets product marketing copy with Gemini + Slack (daily, rate-limited)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow scans your Google Sheets \u003cem\u003eProducts\u003c\/em\u003e 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 \u003cstrong\u003eSlack\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule\u003c\/strong\u003e every day at \u003cstrong\u003e06:00\u003c\/strong\u003e via a Schedule Trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads product rows from Google Sheets\u003c\/strong\u003e that are missing marketing copy (using your selected spreadsheet and the \u003cstrong\u003eProducts\u003c\/strong\u003e sheet).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProcesses items in batches of five\u003c\/strong\u003e to stay within \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e rate limits.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates copy per product\u003c\/strong\u003e by sending product name, features, and target keywords to Google Gemini, producing:\n    \u003cul\u003e\n      \u003cli\u003ea ~\u003cstrong\u003e60-word\u003c\/strong\u003e description\u003c\/li\u003e\n      \u003cli\u003ea \u003cstrong\u003e“META:”\u003c\/strong\u003e SEO meta title line\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSplits Gemini output\u003c\/strong\u003e into separate description and meta title fields (so your sheet columns stay clean).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpserts results back into Google Sheets\u003c\/strong\u003e, then—once all batches finish—\u003cstrong\u003eposts a summary message to Slack\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eKeep an e-commerce catalog up to date by filling missing Google Sheets product descriptions without manual copywriting.\u003c\/li\u003e\n  \u003cli\u003eImprove SEO coverage by consistently generating meta titles for products based on features and target keywords.\u003c\/li\u003e\n  \u003cli\u003eOps-friendly monitoring: receive a daily Slack notification confirming processing completion and batch run status.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes \/ components\u003c\/strong\u003e: Schedule Trigger, Google Sheets (read\/write), \u003cstrong\u003eSplit in Batches\u003c\/strong\u003e, Code, Split, Slack, and Sticky Note for workflow documentation.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\u003c\/strong\u003e: Google Sheets OAuth2, \u003cstrong\u003eGoogle Gemini (PaLM) API credentials\u003c\/strong\u003e, and \u003cstrong\u003eSlack OAuth2\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConfiguration\u003c\/strong\u003e: Select your spreadsheet + \u003cem\u003eProducts\u003c\/em\u003e 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.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45738633494707,"sku":"N8N-17518","price":36.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/skRxiQRiF5-a0xrBqn7Ug_qEYEVQmO.png?v=1785230445","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-auto-generate-google-sheets-product-copy-w-gemini-slack","provider":"N8N Commerce","version":"1.0","type":"link"}