Weekly Google Search Console Report Sent to Google Drive
A weekly n8n workflow rolls up all your Google Search Console search querys from the last 7 days into a summary, then has Google Drive save a copy to Google Drive so your team never has to dig for the numbers.
- 1
Fetch Google Search Console data
Add an
HTTP Requestnode (or the native Google Search Console node if you have credentials set up) and point it at the Google Search Console API. Run on a weekly Schedule Trigger and fetch this week's search querys. Add aSchedule Triggerbefore it if this recipe runs on a timer, or aWebhooknode if Google Search Console can push events directly. - 2
Shape the data with a Set node
Add a
Setnode after the fetch step to pull out the fields you need — e.g.id,title(orname),status, andupdated_atfrom the Google Search Console search query. This keeps the rest of the workflow clean and readable. - 3
Send it to Google Drive
Add a
Google Drivenode set to operationUpload. Connect your Google account, choose the destinationFolder, and pass the file/summary through from the Set node. - 4
Activate and test
Click
Activatein the top-right corner. Trigger a real search query in Google Search Console (or run the workflow manually against existing data) and confirm it lands correctly in Google Drive. Once verified, this runs hands-off.
Frequently asked questions
Do I need to code anything?
No. n8n is a visual, drag-and-drop builder. You connect your Google Search Console and Google Drive accounts, map the fields, and activate — no code required.
Where do I get my Google Search Console API credentials?
In your Google Search Console account settings, look for "API", "Developers" or "Integrations" and generate an API key or token. Paste it into n8n's HTTP Request node (as a header or credential) or the native Google Search Console node if one is available.
Can this run on a schedule instead of in real time?
Yes — swap the trigger for a `Schedule Trigger` set to whatever interval fits (every 15 minutes, hourly, daily). The rest of the workflow stays the same.
Keep every recipe free
FlowRecipesHub is free and always will be. If a workflow saved you time, chip in what you like — it helps us keep the lights on and build the next batch of automations for everyone.
Secure checkout via Paddle · one-time, no account needed
