Troubleshooting missing dynamic fields when creating Google Calendar events from Smartsheet in Zapier
Hello,
I'm trying to create a Google Calendar event from a Smartsheet file using Zapier.
Goal: When the Add to Calendar] column is marked in Smartsheet, I want Zapier to create a detailed calendar event with Dynamic Fields.
Issue: When setting up the Zap (details below), only a few Smartsheet columns show up as available for dynamic text in the Google Calendar event.
Zap setup:
Trigger: Smartsheet > Updated Row (monitoring nAdd to Calendar] column. Here, I can see all the smartsheet columns to choose from?)
Action: Google Calendar > Create Detailed Event (but field mapping options are very limited, screenshot below)
Any idea why I can't see all my Smartsheet columns as options? It’s as if the Google Calendar portion of the Zapier can’t recognize the columns. I have made sure there are values in all columns, made sure to pick a recent Test Record. I tried the “Add comment route” for triggering - still no luck.
Not all columns from the sheet are displayed during configuration.
Columns that are locked based on your sharing permission level won't be displayed.
Trigger sample results contains a lot of No Sample Data values
This happens when data has not been "Saved" in a Smartsheet row yet. To fix, enter some data in a row of your Smartsheet, then click the "Save" icon in top-left of the sheet.
I can't select my Smartsheet attachments or discussions columns.
There isn't currently a way to match file attachments or discussions for Smartsheet Triggers or Actions.
I am trying to get my Gmail attachment into Smartsheet.
There isn't currently a way for Smartsheet actions to receive files provided by certain Zapier file-enabled triggers (Gmail and others).
Zap is not triggering from new rows of data
If the Smartsheet connected to the Zap is currently active, new rows added to a Smartsheet won't trigger the Zap.
To trigger from these newly added rows of data, you will either have to:
Choose another sheet to make the current sheet inactive
Close the Active sheet
Hi @morgansims,
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.
Hi @JammerS, no that response did not provide any additional information that I had not already tried.
You can try adding an extra step “Find Sheet Row” after the updated step, pass in the Row Id from the updated step and review if you are getting all the columns.
in Smartsheet, I want Zapier to create a detailed calendar event with Dynamic Fields.
