Typeform hidden field mapped correctly but Google Sheets lookup returns nothing

[Lujan]

What is your goal?

When a prospect submits a Typeform (pre-filled via URL parameters from
Instantly), use their hidden field email to look them up in Google Sheets,
retrieve their contact details, and send a summary email via Gmail.

What is the problem & what have you tried?

Google Sheets Search Rows returns zero results even though the hidden field
email is confirmed populated in the Typeform execution log. No errors — all
modules run green. Downstream fields come through as null.

Filter config: email column G | Equal to | 1. Hidden: email

Confirmed working:

• Typeform variable tree shows Hidden > email with the correct value
• CSV export confirms email is captured on every submission
• The Google Sheet contains the prospect record with a matching email in column G

Workaround tried: removed Google Sheets module, mapped all fields directly
from Typeform hidden variables (first_name, last_name, company_name,
company_description, full_address, job_title) via extended URL params.
This works but is not the preferred architecture — I want Make to retrieve
contact fields from the sheet using only the email as the lookup key.

Error messages or input/output bundles

No errors. All modules return green. Google Sheets Search Rows outputs an
empty bundle. OpenAI receives null values and writes [Not provided] for all
General Information fields in the output email.

Create public scenario page

https://us2.make.com/public/shared-scenario/QASHn5lxoSA/mc-kenzie-form-submission-worklow-copy

[Stoyan_Vatov]

Hey there,

can you check the google sheet and see if the email matches exactly? Maybe there is some issue with a capital letter? Or an empty space?

[Lujan]

Hi Stoyan! Thanks for replying. We have also considered that but that doesn’t seem to be the case - I even changed the filter to “Text operators: Equal to (case insensitive)” and ran another test with a different email just now and it still doesn’t work.

[Stoyan_Vatov]

Ok this is strange, can you copy an email from the google sheet and try with it directly?

Can you also show a screenshot of how the module is setup on your side? Cause I don’t have the same sheet and when I import the scenario it doesn’t actually show it properly.

[Lujan]

Email: lujan@modern-amenities.com

This is how I am seeing the GSheets module

[Stoyan_Vatov]

Ok and when you search with an existing email it worked?

[Lujan]

No, it has never worked in all the runs I did.
The summary generated always comes back like this:

[Stoyan_Vatov]

Not the summary at the end, check the modules one by one and see where the information disappears.

Start with checking if the sheets module is returning the correct info. Then see if that is being fed to the openAI module and what it’s returning and so on.

[Lujan]

I think the issue is on the hidden field from Typeform.

These are the results I see on the Typeform module:

On the version of the workflow where it’s Typeform –> ChatGPT –> Gmail, I noticed it’s returning as empty.

On the version of the workflow where it’s Typeform –> GSheets –> ChatGPT –> Gmail, I first notice it on the first module, the Gsheets which would expain why the cross-referencing isn’t working.

When checking on the results log on Typeform the email hidden fields do appears so my understanding is that therefore this must be an issue on the mapping.

Do you have any thoughts on what might be going on? Txs