The data is not being added to the google sheet

[Rishabh1]

I have made a workflow in which I am fetching data from facebook ads and appending it to the google sheets, I have several clients and it is working for all other clients but in one client the data is not being added to the sheets.
The data is being correctly fetched as I have tested the workflow the part where the data needs to be appended at google sheet shows successfully updated cells but the changes are not being reflected on the google sheets.

 

[Preeti Paryani]

Hello @Rishabh1,

Could you please provide us with the Workflow URL where you are facing this issue? This will help us investigate the problem more effectively and assist you accordingly.

 

[Rishabh1]

Pabbly

connect.pabbly.com

Here is the URL

 

[Preeti Paryani]

Hello @Rishabh1,

Could you please grant access to the Google Sheets file at [email protected]? This will allow us to investigate the issue more effectively.

Looking forward to your response.

 

[Rishabh1]

Sure,
I gave the viewer access of the sheet for the flow.

 

[Preeti Paryani]

Dear @Rishabh1,

Upon reviewing your Google Sheet, we noticed that formulas are present up to row 1000. As a result, default values have been added to certain cells, causing the workflow data to be inserted below row 1000 instead of the expected location. Please refer to the attached image for more details.

To prevent this issue, kindly ensure that no formulas are pre-filled in the sheet.

Let us know if you need any further assistance.

 

[Rishabh1]

Thank you so much Preeti , I will keep this in mind for making further workflows.

 

[Preeti Paryani]

Hello @Rishabh1,

Thanks for the update, we'd love to hear your thoughts! If you have a moment, please rate us on Google. Your feedback helps us improve.