When someone completes a typeform, I'd like to send that information to a google sheet. I've done it in Zapier. Is there a template or can someone send me a brief how-to? Thank you so much!
I'm not sure I have the full message, but I might have googled it. It was something like the below:
"Could not retrieve values. Insufficient tokens for quota 'ReadGroup' and limit 'CLIENT_PROJECT-1d' of service 'sheets.googleapis.com' for consumer 'project_number:644771627308'."
Hi @Anonymous - could you share more details on the error you're seeing? A screenshot or the full error message would be useful.
Thank you! It does seem to work. But now I'm getting some type of out-of-tokens error. I think this application has a lot of promise but some of the kinks need to be worked out for folks to have confidence in it.
Hi @Anonymous - unforutnately this is an issue in the Designer, the ' in the question is not being escaped properly causing the error. We're working to resolve this, in the meantime a workaround would be to remove the ' from the question name. Please try it out and let us know if you hit any other issues!
Hi Mona - did you have any ideas on why I am getting the error and how to fix it or avoid it?
I'm getting an error: The template validation failed: 'The template action 'Insert_row' at line '1' and column '1019' is not valid: "The template language expression '@{triggerBody()?['2: What's your first name?']}' is not valid: the string interpolation segment starting at position '0' is not terminated. Make sure that every '@{' is followed by its '}'.".'.
Hi,
First create the google sheets with the corresponding columns and then create the flow like below:
I just tested with one submission and flow runs successfully:
Please go ahead and have a try.
Regards,
Mona
#1
WarrenBelz
146,670
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,013
Most Valuable Professional
Share
Report
All responses (
Answers (