{"product_id":"n8n-workflow-google-keyword-volume-cpc-to-google-sheets","title":"n8n Workflow: Google Keyword Volume \u0026 CPC to Google Sheets","description":"\u003ch3\u003eInstant Google Ads keyword metrics—auto-saved to Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow takes your list of keywords, fetches Google Keyword Planner metrics (including search volume and CPC) using \u003cstrong\u003eApify’s Keyword Search Volume Scraper\u003c\/strong\u003e, and appends one clean result row per keyword into \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eManual trigger:\u003c\/strong\u003e You start the workflow by running it manually in n8n.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads configuration:\u003c\/strong\u003e It reads your \u003cem\u003ekeywords\u003c\/em\u003e plus \u003cem\u003ecountry\u003c\/em\u003e, \u003cem\u003elanguage\u003c\/em\u003e, and \u003cem\u003emode\u003c\/em\u003e from a configuration step.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches Keyword Planner data:\u003c\/strong\u003e It sends your keywords to Apify’s \u003cstrong\u003eKeyword Search Volume Scraper\u003c\/strong\u003e and retrieves dataset items with metrics such as:\n    \u003cul\u003e\n      \u003cli\u003eAverage monthly searches\u003c\/li\u003e\n      \u003cli\u003eCPC\u003c\/li\u003e\n      \u003cli\u003eCompetition\u003c\/li\u003e\n      \u003cli\u003eBid range\u003c\/li\u003e\n      \u003cli\u003eTrend\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCleans and structures results:\u003c\/strong\u003e It filters out the actor run summary so only items with a valid keyword are kept, then reshapes fields into clear columns (keyword, seed, volume, CPC, competition, bid range, trend, data timestamp, and charged flag).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends to Google Sheets:\u003c\/strong\u003e It writes the cleaned rows to your selected spreadsheet and worksheet—one row per keyword.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eBuild an SEO keyword spreadsheet for specific targeting (country\/language) with \u003cstrong\u003eGoogle keyword volume\u003c\/strong\u003e and \u003cstrong\u003eCPC\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eRefresh keyword performance snapshots by re-running the workflow as part of your content planning.\u003c\/li\u003e\n  \u003cli\u003eSaaS and agency teams: standardize reporting by exporting Apify Keyword Planner results directly into Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify HTTP Request:\u003c\/strong\u003e Uses an HTTP Header Auth credential with \u003ccode\u003eAuthorization: Bearer \u0026lt;YOUR_APIFY_TOKEN\u0026gt;\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets:\u003c\/strong\u003e Appends rows to your chosen spreadsheet\/worksheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes used:\u003c\/strong\u003e Manual Trigger, \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, Sticky Note, \u003cstrong\u003eHTTP Request\u003c\/strong\u003e, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eRequirements:\u003c\/strong\u003e You’ll need an Apify account (API token) and a Google account. A 50-keyword test is available for initial verification.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45950084317363,"sku":"N8N-19160","price":43.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/2iuvdOHuvb4yDcbaGOZA__Kv6RwIQ8.png?v=1788513273","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-google-keyword-volume-cpc-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}