Get fresh keyword ideas with real search volume and save them to a shared sheet your team can use. Built for SEO and ads teams that need fast research and clean data in one place.

The run begins when another workflow or a manual start sends a list of seed terms into the trigger. Set Keywords passes the array to a request that calls the Google Ads keyword ideas endpoint with your customer id, language, and location. The request includes headers for content type, developer token, and login customer id, and a JSON body that sets geo target and language codes. Results come back as one list, which Split Out turns into single items. Edit Fields keeps only the keyword text, average monthly searches, and competition. Google Sheets Upsert then appends each item as a new row.

You will need a Google Ads account with API access and a Google Sheets account connected in n8n Cloud. After setup, teams can cut research time from hours to minutes, plan content faster, and keep one source of truth for planning. Use it for weekly SEO sprints, PPC build outs, and topic discovery at scale. Adjust page size to control results and tune geo and language to match your market.

• Execute Workflow Trigger starts runs when called by another workflow
• Set Keywords maps the incoming array of seed terms
• HTTP Request calls Google Ads generateKeywordIdeas with OAuth and required headers
• Split Out converts the results list into single items for clean mapping
• Edit Fields extracts keyword text, average monthly searches, and competition
• Google Sheets Upsert appends each result as a new row in your sheet
• Configurable language, geo target, and page size in the request body

• Reduce manual keyword research from 3 hours to 10 minutes
• Streamline idea collection by 80% with one run
• Improve data quality by pulling direct from Google Ads
• Connect Google Ads and Google Sheets without copy paste
• Handle thousands of seed terms with consistent output

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 and Google Sheets. See the Tools Required section above for links to create accounts with these services.
3. Open the node named Generate new keywords. In the Credential to connect with dropdown, click Create new credential and select Google Ads OAuth2 API. Follow the on screen steps to connect your account.
4. In the same node, update the request URL to include your customer id in the path for the keyword ideas endpoint.
5. Add request headers for content type, developer token, and login customer id. Use your values from the Google Ads account.
6. Set the JSON body to include geo target and language codes, and map keywordSeed keywords to the Set Keywords output.
7. Open Set Keywords and map your incoming data to the field named Keyword. For testing, pin sample terms like running shoes and trail shoes.
8. Open the Upsert node. In the credential dropdown, click Create new credential and connect Google Sheets OAuth2. Follow the on screen steps.
9. Select your spreadsheet and sheet tab. Make sure the sheet has columns for keyword, average monthly searches, and competition.
10. Map fields from the Edit Fields node to the matching columns in the sheet.
11. Run a test execution. Confirm the HTTP request returns results and that new rows appear in your sheet.
12. If you see auth errors, check the developer token, customer id, and login customer id. Make sure the Google Ads account has API access.
13. If no rows are added, verify the Split Out field path is set to results and that Edit Fields outputs the expected fields.
14. When tests pass, replace the trigger with your preferred start method, such as a webhook or a schedule that sends seed terms.