Skip to main content
Question

Generate Google Calendar events from new Google Sheets rows -- how to make fields variable?

  • July 19, 2025
  • 2 replies
  • 10 views

Hi, I have never used Zapier before. I am trying to set up a workflow that adds a new event to the calendar whenever the sheet gets a new row (from a form).

The problem is: the responses in the “Create Detailed Event” box don’t seem to be variables that can change (like column headers). Instead, they appear pre-filled with the one event I have in there now.

For example, in my sheet, the Description field has the value “This is a description.” 

Well, the tool fills in “This is a description.”

But if I add another row with a Description set to “This is another description” it doesn’t pick up and add the new value. Meaning not the new time, not the new date, etc.

How do you make these values variable to be filled in with the row contents? I found the Variables screen a bit impenetrable, and I am not sure it’s the right thing anyway.

Thanks for whatever help you can offer!

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

2 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • 34001 replies
  • July 20, 2025

Hi ​@Outsider 

Help link for how to map variables between Zap steps: https://help.zapier.com/hc/en-us/articles/8496343026701-Send-data-between-steps-by-mapping-fields

 

For us to have more info, post these screenshots:

  • how your Zap steps are outlined
  • how your Zap steps are configured in EDIT mode with the field mappings visible in the CONFIGURE tab
  • the top 3 rows of your GSheet

SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 9652 replies
  • July 24, 2025

Hey ​@Outsider, just checking in 👋

Did the guide Troy shared help to get you pointed in the right direction? If not, and it’s a dropdown type of field that you’re wanting to select a dynamic value for you’d want to use the Custom value option and select the relevant field from a previous step. You can learn more about that here: Add custom values to dropdown menu fields in Zaps

Want to make sure you’re all set, so please keep us posted on your progress!