Google Sheets

Connect to a Google Sheet in AirOps

Add Google Sheets as a Data Source in AirOps

To setup a new Data Source, go to ⚙️ Settings —> Warehouse Setup —> Add Source +

  1. Share your Google Sheet with the AirOps email address

    • Copy your uniquely provided AirOps email address from the Google Sheets connection page (example is shown in the form below)

    • Click on the "Share" button at the top right corner of your Google Sheet

    • In the "Share with people and groups" section, paste the AirOps email address.

    • Click the pencil icon to change the permission to "Viewer" (Read access).

    • Click "Send" to share the Google Sheet with AirOps.

  2. Add the Sheet URL in AirOps

Google Sheets Requirements and Formatting

To ensure a smooth connection with AirOps, your Google Sheet must meet the following requirements:

  • No more than 10,000 rows per sheet (we're expanding this limit soon!)

  • Each cell of the first row must include column headers

Now, your Google Sheet should be connected and ready for use within AirOps!

Tip: If you make changes to your Google Sheet (e.g., adding new rows or columns), make sure to refresh the data source in AirOps to see the latest updates

Last updated