Hello @coop3254
as @Liz already mentioned in order to enable integration in your typeform you need to do it manually.
However there might be an approach where you will integrate this manually using Typeform API and Google Sheets API. Please bear with me, as I have never used the Google Sheets API so my knowledge might be limited.
I think you could build a custom integration like this:
1A: Typeform integration:
- integrate Typeform Webhook and receive data from each new submission
1B: Typeform integration (alternative). You will need to run this via cron every few minutes.
- retrieve all typeforms from your account
- then retrieve responses for each typeform
2: Google sheet integration:
- get typeform response data from step 1 (A or B)
- create Google Sheet for each typeform (if it does not exist already)
- you should be able to share the sheet via Google Drive API too
- format typeform responses and write them into the sheet
Please let me know if you build this integration. I can also help with the Typeform part if you need any further help.