I am having issue with Write Row Google Sheets. I have the correct file and sheet selected. I used Append, Has Headers (True), and Individual Fields selected. It will work once, sometimes twice. But it will stop working and nothing with be added to the sheet, although it says successful. I have also noticed that if I delete rows it will stop working also. I am using the Community release. If I completely delete the sheet and start a new and set everything back up, it will print again. Any suggestions?
HI @Anthony_Tipton ,
This behavior is usually related to how the Google Sheets API handles append operations together with header detection in the Write Row activity.
Since you have Has Headers = True and Append enabled, the activity internally tries to determine the next available row based on the header structure. If rows are manually deleted or the header reference changes, the activity may still execute successfully but fail to append data because the detected range becomes invalid.
A few things you can try:
- Ensure Header Stability
- Avoid Deleting Rows in the Sheet
- Use Write Range with a DataTable
- Check Package Version
- Try Explicit Range Definition
If Solution helps you please mark as Solution or let me know if still face the issue or share the logs of error.
Thanks
I appreciate the information. Changing to Write Range and DataTable seems to have corrected the issue.