Log daily keyword positions to a spreadsheet.
Runs every morning, pulls SERP positions for your tracked keyword list, appends a row to Google Sheets, and flags any big drops.
/v1/serp/v1/rankAbout this workflow
Runs every morning, pulls SERP positions for your tracked keyword list, appends a row to Google Sheets, and flags any big drops. It's a Zapier workflow built for rank tracking, wiring the RankParse API into Google Sheets. Pricing is usage-based — about 20 credits / day — with no subscription or per-seat fees.
How it works
- 1
Trigger
Fires from a Zapier trigger — a schedule or an app event.
- 2
Pull RankParse data
Call /v1/serp and /v1/rank for the domains or keywords you track.
- 3
Process
Compare today’s positions against the last run and flag the moves worth acting on.
- 4
Deliver
Push the result to Google Sheets.
Set it up
- 1.Import the starter config below into Zapier.
- 2.Add your RankParse API key as an X-API-Key header credential.
- 3.Connect Google Sheets.
- 4.Set your domains or keywords and a schedule, then run it.
Starter config
A base to adapt — wire it into your Zapier workflow and fill in your inputs.
{
"name": "Log daily keyword positions to a spreadsheet",
"platform": "Zapier",
"category": "Rank tracking",
"rankparse": {
"baseUrl": "https://api.rankparse.com",
"auth": "X-API-Key",
"endpoints": [
"/v1/serp",
"/v1/rank"
]
},
"connects": [
"Google Sheets"
],
"schedule": "0 9 * * *",
"estimatedCredits": "~20 credits / day"
}