Notifications
Clear all
How To
4
Posts
2
Users
0
Reactions
4
Views
Topic starter
Troubleshooting Help Needed: Issue with Googlesheet Row Update module in callin.io Scenario
I’m encountering an issue with a callin.io 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:
- A text parser that retrieves valid data from the Google Sheet.
- This data is derived from the callin.io 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)
Posted : 21/11/2024 2:27 am
Hi
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 callin.io
Posted : 21/11/2024 6:20 am
Topic starter
Thanks.
Are you suggesting I only need to use a single Google Sheets module after parsing?
My goal wasn't to create a new row, but rather to add information from the text parser into existing cells in the last row that was added via Google Sheets from callin.io at the end of all report transcripts we book.
Posted : 21/11/2024 2:15 pm
Hi there!
In your workflow, you're currently creating a row with the summary and transcript first, and then updating that same row with the speaker and text. As a suggestion, you could simplify this by using the “add a row” module directly after the match patterns step.
If you encounter any further issues or have other questions, feel free to share a short Loom video explaining the challenge. We'll do our best to help you out.
Regards,
Msquare Automation - Platinum Partner of callin.io
Posted : 22/11/2024 7:19 am