How do I search ENTIRE Google sheets page for one value

How To
1

Hey everyone,

Not sure if I am having a brain fart but I can’t seem to figure out a solution to this:

I am creating a scenario that pulls data from my docusign account and searches for a value in a Google sheet to determine if that particular docusign envelope has already been used.

I have it set up to search rows of my google sheet to look for {envelopeID}. Then afterwards there is a filter so that if the “envelope ID” does not exist in the sheet, then it continues forward through the scenario.

The problem is that it is searching one row after the next, so if the first row does not contain the “envelope Id”, it moves forward, even if any of the remaining rows DOES contain the “envelope ID”. Or, as another example, if the first row DOES contain the “envelope ID” then it will move on to the second row, which would NOT contain it (because the envelope ID would only ever be in one row, so then it would move forward even though the first row did contain it.

I want to make it so that if the “envelope Id” is does not exist on ANY/ALL of the rows, then it moves forward. How do i do this?

3

Welcome to the Make community!

Would it be possible to provide screenshots of what you are describing?

1. Screenshots of module fields and filters

Please share screenshots of relevant module fields and filters in question? It would really help other community members to see what you’re looking at.

You can upload images here using the Upload icon in the text editor:
Screenshot_2023-10-07_111039

2. Scenario blueprint

Please export the scenario blueprint file to allow others to view the mappings and settings. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.

Screenshot_2023-08-24_230826
(Note: Exporting your scenario will not include private information or keys to your connections)

Uploading it here will look like this:

blueprint.json (12.3 KB)

3. And most importantly, Output bundles

Please provide the output bundles of the modules by running the scenario, then click the white speech bubble on the top-right of each module and select “Download output bundles”.
Screenshot_2023-10-06_141025

A.

Save the bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.

Uploading it here will look like this:

bundle.txt (12.3 KB)

B.

If you are unable to upload files on this forum, alternatively you can paste the formatted output bundle in this manner:

  • Either add three backticks ``` before and after the code, like this:

    ```
    input/output bundle content goes here
    ```

  • Or use the format code button in the editor:
    Screenshot_2023-10-02_191027

Providing the output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

Following these steps will allow others to assist you here. Thanks!

2 Likes
4

Hi @AgentAutomation

If you want to check all the row at once you can use a text aggregator after the google sheet search module and then apply a filter to check if the {envelopeID} does not exist.

If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support
Visit us here
Youtube Channel

2 Likes
5

That worked perfectly! Thank you so much for your help @Msquare_Automation

2 Likes