Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Reports, Analytics & Dashboards

Reports, Analytics & Dashboards

Create Data-Driven SEO Reports from Articles with BigQuery

When a form is submitted with an article, it combines it with BigQuery search data, has OpenAI suggest improvements and saves a report in Google Drive and Sheets.

Import it free Sign in to open it

What it does

# Generate and Save Performance Report

The steps

  1. On form submission
  2. get_article_content
  3. 5_sec
  4. get_status
  5. is_completed
  6. Markdown
  7. Edit Fields
  8. Google Drive
  9. if_sheet_exists
  10. create_new_spreadsheet
  11. get_article_performance
  12. add_sheet_0
  13. add_sheet_1
  14. Merge

23 steps in total.

Similar automations

Data Sync & ETLRoute scored GTM signals from BigQuery to HubSpot with Telegram and Google Sheets14 stepsContent Writing & GenerationCreate Data-Driven UX Personas with Perplexity and OpenAI11 stepsAI Agents & AssistantsChat with Your SEO Data in BigQuery Using OpenAI6 stepsMonitoring, Ops & IncidentsTrack Keyword Rankings in Google Sheets with BigQuery24 steps