- Admin/owner permissions: For triggers and search steps, View Only access to the spreadsheet is sufficient. For create/update actions, you must have full Edit permissions.
- Paid/versioned account: Any version of a Google account can be used with Google Sheets.
- Note: If you use a Google Sheets trigger, you should always turn your Zap OFF before making changes to your spreadsheet, and only turn it back on when you're finished changing the spreadsheet.
When creating a Google Sheets Zap, you will be asked to connect a new account:
Click on that. You should then get a pop-up window from Google asking you to log-in to authorize the connection between that Google Sheets account and Zapier.
If you are already logged in to your Google account on your browser, you will be asked to approve access to Zapier.
After logging in and approving access, you'll be returned back to your Zap and your Google Sheet account will now be successfully connected.