n8n

How to Generate Google Ads Keyword Metrics?

Turn a short keyword list into clear data you can trust. Pull monthly searches, trends, and competition straight from Google Ads. Ideal for content and paid media teams that need quick answers for planning.

Run it on demand with a manual start. A Set node holds up to 20 keywords. The HTTP Request calls the Google Ads generateKeywordHistoricalMetrics method using your account. Results are split into one item per keyword with the Split Out node, so you can push clean rows into a sheet or database. Using official data helps you pick winners, spot seasonality, and sort priorities fast. The flow is simple and easy to maintain.

You will need a Google Ads account, a developer token, and a customer ID. Replace the URL customer id and add your credentials, then connect an output like a database, Google Sheets, or Airtable. Most teams cut research time from an hour to a few minutes and plan campaigns with better confidence. This is useful for quarterly planning, new product launches, and seasonal content decisions.

What are the key features?

  • Manual trigger lets you run checks on demand
  • Set node stores up to 20 keywords in a simple array
  • HTTP Request calls Google Ads generateKeywordHistoricalMetrics to fetch monthly volume, trend data, and competition
  • Uses Google Ads OAuth2 credential with required headers for developer token and login customer id
  • Split Out node breaks the results list so each keyword becomes its own record
  • Output placeholder you can replace with Google Sheets, Airtable, or a SQL database

What are the benefits?

  • Reduce manual research from 60 minutes to 5 minutes for 20 keywords
  • Streamline keyword review by 80 percent with one run
  • Improve accuracy by using official Google Ads metrics
  • Handle up to 20 keywords per run and scale by batching
  • Connect results to your database or sheet for team sharing

How do you set it up?

  1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
  2. You'll need accounts with Google Ads. See the Tools Required section above for links to create accounts with these services.
  3. Open the Set >=20 Keywords node and enter up to 20 keywords as an array. Remove pinned data if you want to feed your own source.
  4. Double click the Get Search Data node. In the Credential to connect with dropdown, click Create new credential and choose Google Ads OAuth2 API. Follow the on screen steps to connect your Google Ads account.
  5. In the same node, set the URL to https://googleads.googleapis.com/v16/customers/YOUR_CUSTOMER_ID:generateKeywordHistoricalMetrics and replace YOUR_CUSTOMER_ID with your Google Ads customer id.
  6. Add required headers in the Get Search Data node: developer-token with your developer token and login-customer-id with your manager id if needed. Confirm the method is POST.
  7. Confirm the request body uses the keywords from the Set node. Keep the existing body structure and map the keyword array into the request fields as configured.
  8. Click Execute node on Get Search Data. Verify the response includes a results field with metrics. Fix any auth errors before continuing.
  9. Check the Split Out by KW node. Make sure field to split is set to results so each keyword becomes a separate item.
  10. Replace the Connect to your own database node with your storage choice. For Google Sheets add a Sheets node and map fields. For Airtable add an Airtable node and map columns. Create credentials in n8n for these tools if you choose to use them.
  11. Run the entire workflow using the manual trigger. Confirm rows or records are created with the right volume, trend, and competition values.
  12. Troubleshoot common issues: 401 or 403 means credential or token problems. 400 often means an invalid customer id or body fields. If the API version changes, update the URL version to the latest.

Tools Required

$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.

Google Ads

Sign up

Basic Access (free): $0, up to 15,000 operations/day; no API usage fees

Credits:
Simon @ automake.io

Similar Templates

Join Futurise to access 1,200+ automation templates

Get instant access to ready-made automation workflows for n8n, Make.com, AI agents, and more. Download, customise, and deploy in minutes.