Connect Claude Code to Google Ads With a Sheets Bridge

The Claude Code connector shown here cannot write directly to Google Sheets. This workflow uses Google Ads scripts and Google Sheets as a bridge: export keyword data, have Claude Code review it, then preview an import script before changes are created. What this workflow covers: Planning the keyword workflow in Claude Code and VS Code Creating Google Sheets API access and resolving the service-account key policy Exporting Google Ads keyword data into Sheets and reviewing recommendations Previewing the import script and scheduling the export and import steps separately Tools used: Claude Code: https://www.anthropic.com/claude-code Google Ads: https://ads.google.com/ Google Apps Script: https://developers.google.com/apps-sc... Google Sheets: https://www.google.com/sheets/about/ Chapters: 0:00 The Google Ads connector limitation 1:34 Planning the keyword automation in Claude Code 3:12 Connecting Claude Code to Google Sheets 4:22 Creating the service account 6:14 Fixing service-account key creation 8:22 Adding the Google Ads export script 9:22 Reviewing keyword recommendations 10:32 Previewing the Google Ads import script 11:25 Scheduling the workflow Book a free automation consult with me: https://cal.com/evan-batky/free-autom... #ClaudeCode #GoogleAds #GoogleSheets