Is it possible to automatically export data to google sheets? | Community
Skip to main content
May 2, 2022
Solved

Is it possible to automatically export data to google sheets?

  • May 2, 2022
  • 1 reply
  • 1541 views

I have someone with Adobe Analytics, they want to combine it with data from other sources to create reports. I know you can manually download a CSV, but is there any way to make some sort of connector or automated process to have their Adobe Analytics data in a google sheet? I don't know if it would be through Adobe Analytics, google sheets, or possibly a third party service.

 

Thanks.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jennifer_Dungan

I've not tried it, but I know there is a generic data connector app for Google Sheets (https://dataconnector.app/) this should allow you to connect to API connections, and we know that Adobe has this.

 

Give this a shot and I'd love to hear if this works out for you.

 

The other option is to use Adobe's Report Builder in Excel (Windows only, unless you are connecting to Customer Journey Analytics), and then use Excel to connect to different sources. This may not be able to be "fully" automated. I tried this once, but the other sources didn't update automatically when the email from the Adobe Scheduler triggered... I didn't have a lot of time to troubleshoot that, but you could give that a shot as well.

 

Good Luck.

1 reply

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
May 3, 2022

I've not tried it, but I know there is a generic data connector app for Google Sheets (https://dataconnector.app/) this should allow you to connect to API connections, and we know that Adobe has this.

 

Give this a shot and I'd love to hear if this works out for you.

 

The other option is to use Adobe's Report Builder in Excel (Windows only, unless you are connecting to Customer Journey Analytics), and then use Excel to connect to different sources. This may not be able to be "fully" automated. I tried this once, but the other sources didn't update automatically when the email from the Adobe Scheduler triggered... I didn't have a lot of time to troubleshoot that, but you could give that a shot as well.

 

Good Luck.