Google sheet - look up and update

[Jon_Field]

What is your goal?

Scenario:

Module 1
Trigger - submit Google Form with an appointment ID (a code)

Module 2
Search a Google sheet for that appointment ID and return the row number.

• i have a filter field within the ‘search Google Sheet’ module to {{appointment ID (Google Sheet) = appointment ID (Google Form)}}

Filter -
‘row number exists’

Module 3
Update spreadsheet row

What is the problem & what have you tried?

The Google sheet row is never found
Error = bundle did not pass through the filter

I have tried every permutation!

Error messages or input/output bundles

The Google sheet row is never found
Error = bundle did not pass through the filter

Screenshots (scenario flow, module settings, errors)

[charles_chukwuma]

@Jon_Field

What is your goal?

Scenario:

Module 1
Trigger - submit Google Form with an appointment ID (a code)

Module 2
Search a Google sheet for that appointment ID and return the row number.

• i have a filter field within the ‘search Google Sheet’ module to {{appointment ID (Google Sheet) = appointment ID (Google Form)}}

Filter -
‘row number exists’

Module 3
Update spreadsheet row

What is the problem & what have you tried?

The Google sheet row is never found
Error = bundle did not pass through the filter

I have tried every permutation!

Error messages or input/output bundles

The Google sheet row is never found
Error = bundle did not pass through the filter

Screenshots (scenario flow, module settings, errors)

This usually happens because the value coming from the form isn’t an exact text match to what’s in the sheet (number vs text or extra spaces). I’d first remove the route filter and confirm the Search Rows module actually returns a bundle. Once it does, the row number will always exist and the update will work.

[Jon_Field]

@Jon_Field

Module 1
Trigger - submit Google Form with an appointment ID (a code)

Module 2
Search a Google sheet for that appointment ID and return the row number.

• i have a filter field within the ‘search Google Sheet’ module to {{appointment ID (Google Sheet) = appointment ID (Google Form)}}

Filter -
‘row number exists’

Module 3
Update spreadsheet row

Thanks for the prompt reply. The search value is an exact text match but no bundle is returned…

[samliew]

Welcome to the Make community!

Based on your screenshots, it appears that you did not run the full scenario. If you did, please take screenshots after you have data from the Google Forms trigger module flowing into the sheets module.

Also, please expand all the fields, otherwise we cannot see what was passed to the Sheets module.

You cannot individually run a single module if you don’t have example input data values for each required field, which you must input into the dialog box when you manually run a single module. This is because when you only run a specific module, the mapped variables in the module’s fields are null (do not contain any value), as the previous modules do not run and produce any output values. Does this make sense?

Instead, try running the full scenario by clicking the “Run Once” button:

Also, your Forms trigger module is a polling trigger. This means the new entry must be created before the scenario is triggered.

To allow others to assist you, please provide the following:

1. All Relevant Screenshots

We need to see what you’re working with to give you the best advice. Screenshots are important because Make is a visual editor — a picture provides us with more context.

It would help us identify the issue by having screenshots of:

• the full scenario, and the zoomed in parts of the scenario that you are referring to (if your scenario is huge),
• a full scenario run/execution from the history (showing output “speech” bubbles),
• relevant module fields (showing how you’ve used any built-in functions, and how you’ve mapped the variables),
• relevant filters between modules (showing which operators and any built-in functions you’ve used, and how you’ve mapped the variables),
• relevant module input/output bubbles,
• if applicable, any error messages,
• and if applicable, any external services (spreadsheet headers/ sample data/ regex101.com/ etc. to show the item/ record exists, and is set up correctly).

2. Scenario Blueprint

Providing your scenario will allow others to quickly recreate and see how you have set up the mappings in each module, and also allows us take screenshots or provide module exports of any solutions we have for you in return. This would benefit you in implementing our suggestions as you can view screenshots of the changes or paste corrected modules back into your scenario.

Need help❓View instructions ◀

A. Export Blueprint

In the scenario editor, click the three dots at the top-right, then select “Export blueprint”.

• You can upload files and images to this forum by clicking on the upload button:
  

  Uploading an attachment here will look like this:
  blueprint.json (12.3 KB)

B. Create Public Share Link

In the scenario editor, click on the Share button:

Read more about the scenario sharing feature in the Help Centre.

3. Downloaded Output Bundles from a Scenario Run

Please provide the input/output bundles of each of the relevant modules by running the scenario, or get the bundles from a previous run from the Scenario “History” tab.

Providing the bundles from a scenario run will allow others to replicate what is going on, especially if there are complex data structures (nested arrays and collections) and external services. This helps mapping the correct raw variable names from collections (instead of the label/display name).

Need help❓View instructions ◀

Click on the white speech bubbles on the top-right of each module and select “Download output (or input) bundles”.

A. Upload a Text File

Save each bundle contents in a plain text editor as a moduleNumber-output.txt file. Open the file to check if it has not added additional formatting or encoded the plain text.

• You can upload files and images to this forum by clicking on the upload button:
  

  Uploading an attachment here will look like this:
  module1-input.txt (1.2 KB)
  module1-output.txt (3.4 KB)

B. Insert a Formatted Code Block

If you are unable to upload files on this forum, alternatively you can paste the bundles AND format them correctly.

_{Formatting IS Important!}

Here are some ways to provide text content in a way that it won’t be modified by the forum.

• Method 1: Type code fence manually —
  Manually type three backticks ``` in a separate line before and after the content, like this,

  ```
  text goes here
  ```
  

• Method 2: Highlight the pasted content, then click the preformatted text/code button —
  

• Method 3: Upload your file elsewhere and share the public link —
  This method is only advised for large files exceeding the forum upload limit.

Sharing these details will make it easier for others to assist you, so that you can get better answers, faster.

— @samliew

[juan_burstein]

Hey Jon,
Did you try running the search module manually? (I mean run only that module and input the value manually)

[Msquare_Automation]

Hi @Jon_Field ,

Kindly ensure that the appointment_id exactly matches the corresponding value in the sheet.

[COMMUNITY] -TEST.blueprint(3).json (42.4 KB)

For your reference, I have shared the scenario blueprint. Please review it and let me know if you find any issues or discrepancies.

Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation