Workflow templateTrack keyword rankings in a sheet each week
Checks the search position of every keyword on your list, appends the history to a sheet and reports the moves.
Workflow illustration
01Trigger
TriggerEvery Monday at 08:00 AM UTC, read the keyword list from the Google Sheets spreadsheet id you choose in setup.
02Da
DataforseoLook up each keyword's search position with Dataforseo.
03
Custom stepAppend one row per keyword to the history worksheet in that spreadsheet with today's date, skipping keywords that already have a row for this week.
04
Custom stepCompare the new positions with last week's rows.
05Sl
SlackPost a note to the Slack channel id you choose in setup naming which keywords moved up or down.
06
OutputFinish
How it runs
This is the brief Whenever builds from. Change any of it in plain words before you publish.
When
Every Monday at 08:00 AM UTC, read the keyword list from the Google Sheets spreadsheet id you choose in setup.
Then
- Look up each keyword's search position with Dataforseo.
- Append one row per keyword to the history worksheet in that spreadsheet with today's date, skipping keywords that already have a row for this week.
- Compare the new positions with last week's rows.
- Post a note to the Slack channel id you choose in setup naming which keywords moved up or down.