Google Sheet Not Updating Since April 14th
Status: Open · Asked by Tejo Waskito Effendi on · 0 views
I have a workflow to update google sheet from Google Drive folder ID.
URL: https://connect.pabbly.com/workflow/mapping/IjU3NjYwNTZkMDYzNDA0MzU1MjY4NTUzMDUxMzYi_pc
1. It can capture data when sending test request even though google drive trigger is shown as deprecated. Only update google sheet step is not working while testing the workflow.
2. The last history only on April 14th when it should be triggered more than once after April 14th.
Other question, how to update google sheet on column BA and others? I can only update column A to AZ.
Hello @sampaht,
It seems you have changed the trigger of your workflow, and I can find two new task histories for today's date.
The last history only on April 14th when it should be triggered more than once after April 14th.
There is a column limitation for "Google Sheet: Add New Row" which is till AZ.
how to update google sheet on column BA and others? I can only update column A to AZ.
To add more data beyond this, then in that case you need to use "Append Values", which has no limits-
[IMG alt="1709103809575.png"]https://forum.pabbly.com/attachments/1709103809575-png.38859/[/IMG]
You can refer to this video tutorial. This will work for you as per your requirement -
There is a column limitation for "Google Sheet: Add New Row" which is till AZ.
I want to update row. Not append values
Please allow us some time to look into this concern. We will get back to you shortly.
Is it possible if I use multiple column as trigger for pabbly connect?
I want the webhook to monitor updates on column A and BG on this sheet, maybe later I will need to monitor update for another sheet in the same workbook.
Hello @sampaht,
Currently, it is impossible to set multiple columns as trigger columns; only a single column can be used to trigger the workflow.
Additionally, regarding your previous requirement, please note that the "Update Row" action in Google Sheets can only update columns up to AZ. This is a current system limitation and cannot be extended beyond that at this time.
We appreciate your understanding.
Can I use multiple Google account to attach each webhook to?
User A will handle column A trigger
User B will handle column B trigger.
Or what kind of solution/workaround can you offer for multi column trigger in Google sheet?
There is no solution or workaround for a multi-column trigger in Google Sheets. It is not possible to set multiple columns as trigger columns.