I'm trying to set up a Zap that triggers from a Google Sheet, but the sheet I'm trying to use isn't showing up in the "Spreadsheet" dropdown. Does anyone know why this might be happening? Also, could it be related to the fact that this sheet is already being used in another Zap? Any help would be appreciated — thanks!
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
- 34068 replies
Hi
Help links for using GSheets in Zaps: https://zapier.com/apps/google-sheets/integrations#help
Google Sheets: Spreadsheet doesn't appear in the dropdown menu
Updated 1 year ago
Symptoms
You're trying to connect a Zap to a Google Sheet, but the spreadsheet doesn't appear in the Spreadsheet dropdown menu in the Zap editor.
Causes
There are two main reasons why this might be happening:
- Incorrect file format: The spreadsheet is not saved in the correct file format. Google Sheets can open and edit .XLSX files, but Zapier can only connect to Google Sheets that are saved as Sheet file.
- Spreadsheet permissions: The spreadsheet may not be shared with the Zapier account that you're using. To use a spreadsheet in a Zap, it must be shared with the Zapier account with at least view permissions.
How to fix it
To fix this problem, follow these steps:
- Save the file as a Sheet. Learn more about converting files to Sheets.
- Check spreadsheet permissions. Make sure that the spreadsheet is shared with the Zapier account that you're using. To do this:
- Open the spreadsheet in Google Sheets.
- Click File > Share.
- Enter the email address of the Zapier account that you're using and set the level of permission.
- For trigger and search actions, you need at least view permission.
- For create and update actions, you must have editor permissions.
- Reload the list of spreadsheets. If you've already saved the spreadsheet as a Google Spreadsheet and checked the permissions, you may need to reload the list of spreadsheets in the Zap editor. To do this:
- Click the Spreadsheet dropdown menu.
- Click Load More.
- Select your spreadsheet name.
- If your spreadsheet name still does not appear, follow this tutorial for empty or missing items.
+6- Zapier Staff
- 3527 replies
Hi
We just wanted to see how everything is going with your Zap. Did Troy's recommendation get the job done? Feel free to reach out if you need further assistance with your Zap. We're glad to address any concerns and assist you.
We're looking forward to your response.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.