How can I use Supermetrics to create a dashboard sheet in Google Drive showing the turnover of each day, from Shopify, and the cost of Facebook Ads spents?
Shopify is not yet available through Supermetrics. We choose the next data source connector in to development by voting results. You can participate in the voting at https://support.supermetrics.com/discussions/topics/19000015989
We keep adding new sources on a fast pace, and for example following us on twitter: @Supermetrics you'll get the info as soon as new sources have been added to Supermetrics.
For Facebook Ads spend it is fairly simple to make the query and set up the auto-refresh trigger. Instructions can be found from: