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 / Monitoring, Ops & Incidents

Monitoring, Ops & Incidents

Track Keyword Rankings in Google Sheets with BigQuery

When you run it, it pulls tracked keywords and URL rankings from BigQuery and writes the ranking history into Google Sheets.

Import it free Sign in to open it

What it does

adjust this node if you want to start with more historical data

The steps

  1. When clicking ‘Test workflow’
  2. Get Tracked Keywords
  3. Code
  4. Get Ranking Keywords by URL
  5. Insert URL Rankings
  6. Domains
  7. Split Out
  8. Loop Over Items
  9. Merge Loop Data
  10. Google Sheets
  11. Sort
  12. If
  13. Set Date
  14. Get date

24 steps in total.

Similar automations

Monitoring, Ops & IncidentsTrack Keyword Rankings in Postgres with BigQuery Data21 stepsMonitoring, Ops & IncidentsTrack SEO Keyword Rankings by Email with Groq AI10 stepsMonitoring, Ops & IncidentsMonitor Google Keyword Rankings with Bright Data MCP10 stepsMonitoring, Ops & IncidentsTrack Website Keyword Rankings with SERP Data and Alerts18 steps