Unanswered

Send Typeform Info to Google Sheets

(0) Share

Report

Posted on by Community Power Pla...

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!

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (0)

v-monli-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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 '}'.".'.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi Mona - did you have any ideas on why I am getting the error and how to fix it or avoid it?

Was this reply helpful? Yes No
Tessa Kloster on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Tessa Kloster on at

Like (0)

Report

Hi @Anonymous - could you share more details on the error you're seeing? A screenshot or the full error message would be useful.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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'."

Was this reply helpful? Yes No
DSMagic 2 on at

Like (0)

Report

I'm getting the same error

Was this reply helpful? Yes No