Google Ads Scripts in Spreadsheets: New Add-on | ClickOnline360

Blog

Our digital marketing blog

Google publishes its Add-on for Adwords Sheets

Google has launched Adwords Sheets, a handy tool for extracting data from Google Analytics, Adwords, and Adsense directly into Google Sheets. Called the Adwords Sheets Add-on, it allows you to quickly import data from Google AdWords into Google Sheets to create customized, easy-to-update analyses and reports.

How does Adwords Sheets work?

To start using the AdWords add-on, you must install the add-on from Google Chrome and authorize access to your AdWords accounts. You can also link it to a My Client Center (MCC) account, which also allows you to select multiple accounts and import data into a single report. With the add-on, you can choose metric columns, set filters to narrow the scope of the data, and name the report from a sidebar in the "Report Settings" tab. Once opened, the report data will be available in a new tab with the name you assigned, allowing for easy identification and access. To edit a report, you can return to the "Add-ons" drop-down menu and select "Edit a Report" from the AdWords overflow menu. In that section, you will also find the option to update reports with the most recent data.

Sharing Adwords Sheets reports

Another advantage of the AdWords add-on is that you can share reports with anyone, just like with Google Sheets. You can also control who can see them, thanks to the privacy and sharing features. In conclusion, the new Google Sheets add-on makes it easy to create, run, and update AdWords reports, and although it's still in beta, reviews have been very positive. You can download the beta version here. If you want to know all the latest news about Google AdWords, we'll tell you about it here .