GoogleSheet is not updating row

How To
1

Troubleshooting Help Needed: Issue with Googlesheet Row Update module in Make.com Scenario

I’m encountering an issue with a Make.com scenario designed to update a Google Sheet. Here’s a summary of the setup and problem:

Scenario Setup

  • The “Googlesheet Update Row” module is supposed to update the last added row in columns “J” (Speaker) and “I” (Text).
  • The data for these columns is pulled from:
    1. A text parser that retrieves valid data from the Google Sheet.
    2. This data is derived from the VAPI End of Call Report/Transcript.
  • Both modules (the one pulling and the one updating) are connected to the same Google Sheet and work within the same sheet/tab.

Current Behavior

  • The module fails to update the last added row in columns “J” and “I” as expected.
  • I’ve attached the exported blueprint file for reference.

Request

Could someone help me figure out why the last row isn’t being updated correctly? Any tips or troubleshooting ideas would be greatly appreciated!
text-parser.json (39.7 KB)

1 Like
3

Hi @Shahram_Sedehi

this seems correct. What issue are you facing with this?? Alternatively, you can remove “update a row” module and use only “add a row” module after math pattern.

Regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation

4

Thanks.
Are you saying I only need to use only one google sheet module after parsing ?
I did not want to create a new row, but add info from the text parser into other cells in the last row that was added via google sheet from Vapi end of all repor transcript we book.

1 Like
5

Hi @Shahram_Sedehi

In your workflow, you are creating a row first with summary and transcript, and then you are updating the same row with speaker and text. For that we suggested you to just use “add a row” module after match patterns.

If you have any other concern, you can share a short loom to explain the challenge. we will try to assist you further.

Regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation