Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

Troubleshooting missing dynamic fields when creating Google Calendar events from Smartsheet in Zapier

  • April 25, 2025
  • 4 replies
  • 34 views
M

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 [Add 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. 

 

 

Thanks in advance! 

Morgan

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Troy TessaloneZapier Orchestrator & Solution Partner
  • Zapier Orchestrator & Solution Partner
  • 34079 replies
  • April 25, 2025

Hi ​@morgansims 

Help links for using Smartsheet in Zaps: 

https://zapier.com/apps/smartsheet/integrations#help

https://help.smartsheet.com/articles/2006869-smartsheet-integration-with-zapier

https://help.smartsheet.com/articles/2103362-creating-zaps-in-zapier

https://help.smartsheet.com/articles/2481321-connect-applications-with-zapier-integration

 

 

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

⚡ Troy Tessalone - AutomationAce.com | Platinum Authorized Zapier Solution Partner | #1 Zapier Community Contributor
JammerS
Forum|alt.badge.img+6
  • JammerSZapier Staff
  • Zapier Staff
  • 3527 replies
  • April 28, 2025

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.

M
  • morgansimsBeginner
  • Author
  • Beginner
  • 1 reply
  • May 2, 2025

Hi ​@JammerS, no that response did not provide any additional information that I had not already tried. 

Mohammad_Shahzaib_Nawaz
Forum|alt.badge.img+3

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.

 

 

www.linkedin.com/in/mohammad-shahzaib-nawaz-986618136
Terms & ConditionsAccessibility statement