Is there a way to bypass Google sheets altogether and push the results of a Supermetrics query directly into a redshift database? It seems like you can name a SQL database as a source, but not a destination.
My ultimate goal here is to join the data we scrape from Facebook, Apple, etc. with other data that we store in a redshift database, since right now the two places do not directly talk to each other. I suppose I could just go source>GoogleSheet>redshift, but was wondering if it was possible to cut out the middle step.
thanks for your question!
Have you checked out Supermetrics API? It is a feature we're developing for these kind of purposes, and at the moment it is in beta. Please start a trial on it to see if it suits your needs.
You can access our API query builder at supermetrics.com/tools. There you can create an API account, log in to data sources, and create queries. For each query, you get a URL that you can then use where ever you want to have the data.
We are developing connectors to various data analysis & visualisation tools. Currently we support Tableau (instructions here: https://docs.google.com/document/d/18YwGFK2NtuwyHrdCLklanR4AkG1sTc-5VeEmmLfebOY/edit). It's also possible to use these query URLs in an ETL process to bring data into your data warehouse.
Instructions for the API tools can be found here: https://docs.google.com/document/d/177e4-SmUGziyT7jxrc9yh2rhMXjmGY-YRt2tTyewS6M
Heidi / Supermetrics team