The user explains a problem with the Google Sheets “Update Row” step in an n8n–ManyChat integration. Although all fields are mapped correctly and the schema appears properly set, the output remains empty when trying to update rows. The user has tried multiple fixes but hasn’t been able to resolve the issue.
Please see this video
Thank you,
Samar Abbas
xamarabbas214@gmail.com
I’ve seen this in some of my workflows, and now this is the only way I run it:
Remove one of your Google Sheet nodes: “Add Rows” or “Update Rows”.
You are essentially combining the two with one Google Sheets node with the “Update or Append Row” operation and then match the column of your choice. (appointment date/time should work fine.) But it will be stronger if you tie in a conversation ID instead.
Hi, thank you for replying. Can I remove both “Add Rows” and “Update Rows” and use only “Update or Append Row”? I will it work perfectly.
Sure, I’ll use the conversation ID instead of the appointment date/time.
Yes you can. It has the ability to match both of those nodes, and it is less for the model to think about when it comes to making decisions on tool use.
Goodluck!
I have fully explained the solution inside the video along with demo, I hope it works for you. It’s actually a date time format issue inside sheets, I have recorded video of implmenting the solution but I don’t know it’s going to failed while uplaoding because of size issue. I have uploaded it on my drive so that you can clearly see the issue where you’re lacking.
Here is drive link: https://drive.google.com/file/d/1pUF1rS2uXfI8J_1tXbIyi0L1cv_dmCdQ/view?usp=sharing
Thank you @i211671_Farhan_Javai I will watch it shortly
samar, If I’m the one who stuck at tha same scenario then what I’ll do is to debug and trace the average time of every node. From this procedure, I’ll get an idea actaully which node is taking too much time to execute and after this I’ll take initiatives to optimize the time
@i211671_Farhan_Javai How we can optimize the time?
This is how I would operate your workflow, keep in mind I am blind to the exacts of your process, but it should be effective in saving time, and token spend.
Here is the link to the video.
Also to note: if you are going to use more workflows that connect to the same sheets etc, that is when the MCP’s (end of video) will be most effective.
I hope that helped!
