User Tools

Site Tools


google_sheets

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

google_sheets [2021/05/27 11:36]
windsor_ai created
google_sheets [2021/06/18 00:13] (current)
windsor_ai
Line 1: Line 1:
 ====== Google Sheets: Frequently asked questions  ====== ====== 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?**+==== 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]]   * 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]].   * 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]].
  
google_sheets.1622111787.txt.gz ยท Last modified: 2021/05/27 11:36 by windsor_ai