Unable to create a Zap with dynamic entry to my email upon a form is submitted.

Hi @JHL 

Good question.

To help give us more context, please post detailed screenshots with how your Zap steps are configured.

You can map dynamic variables using the ‘Custom’ option.

@JHL 

Use the ‘Custom’ option to map dynamic variables.

It took a second to figure out how to create and insert the field, but after that worked like a charm. Thanks Mark. You’ve been so helpful I’m likely to be back! I will work to try and figure out myself first.

@JHL 

These Zap apps are NOT in Beta.

1. GSheets
2. GForm

The reliability of the Zaps is dependent on:

1. how the Zap steps are configured
2. how the GSheet that saves the GForms is configured and being used
3. the data used in the test

We would need to see full screenshots with how each Zap step is configured.

The Google Sheets trigger is marked "instant" but it still takes a few minutes to trigger

The triggers for Google Sheets are unique among Zapier triggers. When there is a trigger event in the spreadsheet, Zapier gets a notification webhook from Google about this. After that, Zapier sends Google Sheets a request for new data, so it uses both the polling and instant trigger methods. This process takes about 3 minutes overall.

While not being "instant", these triggers are faster than regular polling ones, as they don't depend on the polling interval of the plan your account uses.

As always, thanks for the very speedy reply Troy.

My comment about “Beta” was because when I started this quest a week or so ago and did a search for Zaps one of the GForm Zaps said “(Beta)” on it. It may have been GForm hooked to something other than Gmail. To your point, when I look at the Form-Gmail app today there is no Beta tag.

I will say that back when I was writing code and managing a small group of programers, if the “test” said “works”, but when you tried a live test it didn’t work, we labeled either the testing code or the deployable code to still be in Beta.

Additionally, me local group are young college students who were raised with google and have zapier experience. Perhaps I put too much confidence in them. I will say they are not a patient crowd. For me, it does testify to the point that there are a number of people having issues. 

That said, I’m pondering which screenshoots might be of greatest value. I’ve sent you shots of most of the Action half of the Zap. As noted, the Zap works well when you ‘test it’ by pulling one of the GForm’s existing spreadsheet records in the Response1 sheet. Also, the GForm sent me an email saying a new Form response has been submitted, so I know the GForm trigger for a new response is working.  It’s hard for me to form an hypothesis as to why the Zap doesn’t pick up the newly created row int he GForms response sheet.

Anyway, here is a screenshoot of the Zap’s triger. Triger Screenshot

If there is some specific information you think would help understand what is happening it would help me if you could described the specific additional screenshoot you think would be helpful. Thanks again.

Hi. This is a little confusing. I have been working on this issue for awhile. There is a lenthy thread under JHL. I’ve created a Zap GForm to Gsheet that works fine when you test it as the last step. It draws the respondents Email from the form and adds the respondents first name to the Gmail text. It works great on any record already in the Gsheet attached to the GForm (Response1 sheet). However, when I submit a form a new row is added to the sheet and GForms notifies me that a new response has been submited. However, the Zap does not fire. All very confusing. I’ve include screenshoots in the lenthy thread posted under JHL in the community. Would love any suggestions anyone might have. Thanks.