How it works
To move data from Google Business Profile to Google Sheets automatically, use a ready-made scenario — no manual exports.
- Starts when: When clicking 'Execute workflow'
- Then: Find top trending topics
- Then: Select a clean trending topic
- Then: Add topic to Google Sheets
- Then: Get most recent topics from Google Sheet
- Then: Generate content and image prompt using Perplexity AI
- Then: Parse Content from string to JSON
- Then: Update Google Sheet with generated content
- Then: Create a post
- Then: Generate featured image using HuggingFace FLUX
- Then: Update name and extension of image
- Then: Upload image to WP media Library
- Then: Assign image to an article as a Featured image
You can launch this Google Business Profile + Google Sheets integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.