Step-by-step walkthrough: How to connect Google Ads to Google Sheets.
1
Get Add-ons
Select Add-ons and choose Get Add-ons. This action will redirect you to the Google Workspace Marketplace.
2
Search Superjoin
In the Google Workspace Marketplace pop-up window, search for “Superjoin”.
3
Click on Install
Click on Extensions from the Google Sheets menu.
Note: For the best experience, install Superjoin where there’s only a single account logged in the Chrome profile.
4
Launch Superjoin
Once installed, navigate back to the Extensions menu tab in Google Sheets. Launch Superjoin from here. You should now see Superjoin running as a side panel on the right side of your screen.
5
Pick Google Ads
Click on “Connect new Source” and select Google Ads from the list of available data sources.
6
Connect your account
Follow the prompts to connect your Google Ads account.
7
Select campaigns and metrics
Select the campaigns, ad groups, and metrics that you want to include in your report.
8
Apply filters
Apply any necessary filters to narrow down the data you want to work with.
9
Click Import
Now simply click on the “Import” button to bring this selected data into your Google Sheets.
10
Data pulled! Setup an auto-refresh schedule.
Superjoin lets you refresh your imported data instantly with one click or set it to auto-refresh on a pre-set schedule. This way, you won’t need to manually update your Google Ads data in Google Sheets to reflect changes from the source.
Step-by-step walkthrough: How to connect Google Ads to Microsoft Excel
1
Launch Add-ins
Click on Add-ins on the right side of the Excel toolbar.
2
Get Add-in
Click on the searchbar and type “Superjoin”. The results would show our add-in under the More search results section.
3
Authenticate with your Microsoft Account
Once Superjoin launches as a side panel, just click on Sign in with Microsoft and follow the steps to authenticate your Microsoft Office account with Superjoin.
4
Launch Superjoin
You should now see Superjoin running as a side panel on the right side of your screen.
5
Pick Google Ads
Navigate to Sources, click on “Connect new Source” and select Google Ads from the list of available data sources.
6
Connect your account
Follow the prompts to connect your Google Ads account.
7
Select campaigns and metrics
Select the campaigns, ad groups, and metrics that you want to include in your report.
8
Apply filters
Apply any necessary filters to narrow down the data you want to work with.
9
Click Import
Now simply click on the “Import” button to bring this selected data into your Microsoft Excel spreadsheet.
10
Data pulled!
Superjoin lets you refresh your imported data instantly with one click. This way, you won’t need to manually update your Google Ads data in Excel to reflect changes from the source.
Hope this guide helped you pull data from your Google Ads to your spreadsheet.
If you have any further doubts, please don’t hesitate to reach out to our support team at support@superjoin.ai. Thank you!