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 +
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.
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