i started recently n8n and followed basic workflow, for the one with google Sheet (aka chabot using a subworkflow with Google Sheet). In the subworkflow, I managed to make the OAuth authentication, but the subworkflow is working.
But the google sheet node doesn’t seem to write to the sheet i provided, but instead creates a new empty sheet. I thought it should write the prompt ans response of the AI to the google sheet
Hello, I use Oath2 for my Google sheet for a similar workflow it should work fine. Make sure you have chosen append or update row for operation, have enabled the APIs for Google sheet, calendar, email and drive, manual map the columns then it should work perfect. Hope it helps.
Ok thank you for your help