Skip to content
Google Sheets Searc...
 
Notifications
Clear all

Google Sheets Search Rows not returning Row Number

4 Posts
2 Users
0 Reactions
5 Views
Omri_Sherman
(@omri_sherman)
Posts: 3
Active Member
Topic starter
 

In this Scenario I have an incoming call from callin.io via webhook, which functions correctly. It then proceeds to search for rows in Google Sheets to identify the row corresponding to the number that was called via callin.io. The process works, but I'm unable to retrieve the row number from the search results. The 'Update Row' action updates a different cell than the one intended in the row with the phone number. Any assistance would be greatly appreciated.

blueprint (2).json (107.8 KB)

 
Posted : 28/04/2025 12:49 am
samliew
(@samliew)
Posts: 293
Reputable Member
 

Welcome to the callin.io community!

You haven't provided enough information for us to reproduce the issue and any errors.

Please share a screenshot of your Sheets module's output, similar to this:

To help others assist you, please provide the following:

1. Relevant Screenshots

Could you please share screenshots of your entire scenario? Also, include screenshots of any error messages, module settings (fields), relevant filter settings (conditions), and module output bundles. We need to see your setup to offer the best guidance.

You can upload images here using the upload icon in the text editor:

We'd appreciate it if you could upload screenshots directly here rather than linking to external sites. This allows us to zoom in and prevents tracking cookies from third-party sites.

2. Scenario Blueprint

Please export your scenario blueprint. Sharing your blueprint file will enable others to quickly replicate your setup and see how you've configured mappings in each module. It also allows us to provide screenshots or module exports of potential solutions, which you can then easily paste back into your scenario editor.

To export your scenario blueprint, click the three dots at the bottom of the editor and select ‘Export Blueprint’.

You can upload the file here by clicking this button:

3. Output Bundles of Modules

Please provide the output bundles for each relevant module by running the scenario. You can also retrieve this from the History tab without re-running your scenario.

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

A. Upload as a Text File

Save the contents of each bundle in a plain text editor (without formatting) as a bundle.txt file.

You can upload the file here by clicking this button:

B. Insert as Formatted Code Block

If you cannot upload files on this forum, you can alternatively paste the formatted bundles. The two methods for formatting text so it remains unchanged by the forum are:

  • Method 1: Type code block manually

    Add three backticks ``` before and after the content/bundle, like this:

    ```
    content goes here
    ```

  • Method 2. Highlight and click the format button in the editor

Providing the input/output bundles will allow others to replicate your scenario, especially with complex data structures (nested arrays and collections) or when external services are involved. It also helps in mapping raw property names from collections.

Sharing these details will make it easier for others to assist you.

 
Posted : 28/04/2025 2:53 am
Omri_Sherman
(@omri_sherman)
Posts: 3
Active Member
Topic starter
 

Please let me know if I've uploaded the necessary information to help resolve this challenge.

 
Posted : 28/04/2025 8:22 pm
samliew
(@samliew)
Posts: 293
Reputable Member
 

There are no row numbers as there are no search results.

If you wish to prevent the remainder of the scenario from executing when no results are found, insert a filter subsequent to the search module. This filter should verify if the Total number of bundles equals 0.

Hope this assists! Feel free to reach out if you have any additional questions or encounter any problems.

 
Posted : 29/04/2025 3:15 pm
Share: