Blog articles from store products — a draft for each

The scenario takes products from Pipedrive, the AI writes an article for each, saves it in Google Sheets and creates a blog draft, and emails a report to Mailjet.

  • An article per product
  • Product data in Google Sheets
  • A ready draft in the blog
  • A report to Mailjet

How it works

To move data from Pipedrive to Google Sheets automatically, use a ready-made scenario — no manual exports.

  1. Starts when: When clicking ‘Test workflow’
  2. Then: Shopify
  3. Then: variables
  4. Then: Product Data in Google Sheet
  5. Check: Loop Over Items
  6. Then: Wait
  7. Then: Gmail
  8. Then: AI Agent
  9. Then: Code
  10. Then: Google Sheets1
  11. Then: Create Blog As Draft
  12. Then: Simple Memory
  13. Then: OpenRouter Chat Model

You can launch this Pipedrive + Google Sheets integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.