google_sheets

Google Sheets: Frequently asked questions

I have costs in multiple sheets and would like to import them to Windsor.ai. What is the easiest way?

Add your Google Sheets as per instructions
Merge multiple sheets into one using the query command.
The formula below merges the sheets programmatic_cost and email_costs into one single sheet
```
 =QUERY({programmatic_spends!A2:G200;email_spends!A2:G200},"select * where Col3 <>''") 
```
The result should look like this

More information about the query command can be found in the Google Sheets Documentation.

google_sheets.txt · Last modified: 2021/06/18 00:13 by windsor_ai