← All integrations
Google Ads™ API™

Google Ads™ API™ → Google Sheets™

Read-only Google Ads™ account discovery and GAQL reporting data.

API Import for Google Sheets™ lets you connect Google Ads™ API™ with the most popular apps, so you can automate your work and have more time for what matters most — no code required.

Google OAuth

Google Ads™ API™ (formerly AdWords API) is Google's paid advertising platform. Connect to pull campaign performance, keyword reports, search term analysis, and ad-level metrics directly into Google Sheets™. Supports GAQL (Google Ads™ Query Language) for flexible reporting across campaigns, ad groups, keywords, search terms, and individual ads.

Example prompts
“List my accessible Google Ads™ customer accounts”
“Get Google Ads™ campaign performance for customer 123-456-7890”
“Get Google Ads™ keyword performance for customer 123-456-7890 during LAST_30_DAYS”
“Get Google Ads™ ad group performance for customer 123-456-7890”
“Get Google Ads™ search term report for customer 123-456-7890”
“Get Google Ads™ individual ad performance for customer 123-456-7890”
How to get credentials
  1. Open API Import for Sheets from the Google Sheets™ Extensions menu.
  2. Select Google Ads™ API™ from the API selector.
  3. Click Connect and authorize your account.
  4. Your credentials are stored securely — no copy-pasting required.
→ View in docs

Ready to connect Google Ads™ API™ to Google Sheets™?

Install the free add-on and start pulling data in minutes.

Install Free on Google Sheets™