GSheet Integration Issue: Automation Shows Success, No Data Populated

Hi there, GSheet integration isn't working for me. I have set up the automation in the table and the spreadsheet correctly. It isn't an API rate limit issue. Clay shows automation was successful - "Row added" - but the spreadsheet is not populated. Happy to share the spreadsheet privately. It has all the correct sharing permissions. Please advise 🙏