====== 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 [[https://onboard.windsor.ai|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 \\ <code> =QUERY({programmatic_spends!A2:G200;email_spends!A2:G200},"select * where Col3 <>''") </code> \\ The result should look like this \\ {{ :merging_queries_google_sheets.png?nolink&800 |}} \\ More information about the query command can be found in the [[https://support.google.com/docs/answer/3093343?hl=en|Google Sheets Documentation]].