User Tools

Site Tools


Google Sheets: Frequently asked questions

I have costs in multiple sheets and would like to import them to 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