Pull new backlinks into Google Sheets with DataForSEO and Gmail email report
UnknownWhat this workflow does
This workflow has 16 nodes and runs on a schedule (every day at 09:00). Along the way it connects Google Sheets, Gmail and Dataforseo (community).
How it runs
Trigger: On a schedule (every day at 09:00).
- Initialize "items" field (Edit Fields (Set)): sets 1 field: items
- Set "items" field (Edit Fields (Set)): sets 1 field: items
- Get new backlinks (Data For Seo Backlinks Api): get backlinks
- Merge "items" with DFS response (Edit Fields (Set)): sets 1 field: items
- Has more pages? (If): checks a condition and branches into true / false
- Filter: keeps only the items that match a condition
- Create spreadsheet (Google Sheets): work with spreadsheet
- Prepage columns for Google Sheets (Edit Fields (Set)): sets or maps fields
- Append columns (Google Sheets): append or update
- Set final "items" field (Edit Fields (Set)): sets 1 field: items
…plus 5 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-dataforseo is verified or supports 3.0 (used in Get new backlinks).
Nodes used (9)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Aggregate
n8n-nodes-base.aggregate - Gmail
n8n-nodes-base.gmail - Edit Fields (Set)
n8n-nodes-base.set - Data For Seo Backlinks Api
n8n-nodes-dataforseo.dataForSeoBacklinksApi - If
n8n-nodes-base.if - Filter
n8n-nodes-base.filter - Split Out
n8n-nodes-base.splitOut
From the author
This workflow helps you keep track of new backlinks by automatically generating a daily report in Google Sheets with the DataForSEO API, and delivering it via Gmail. On each run, the workflow connects to the DataForSEO Backlinks API to retrieve the latest…