Send data from Framer to Google Sheet (Custom Form)

Learn how to send data from Framer to Google Sheet using a custom form!

Here's the app script code:
------------------------------------- CODE STARTS -------------------------------------
function doPost(e) {
var row = [
]

}

------------------------------------- CODE ENDS -------------------------------------

Here's my official Figma paid course which you can check out on:

Use the AMSUBSCRIBER voucher code to get 50% off!

Be sure to subscribe and hit the notification icon! It really helps me help you and others like you be better designers, freelancers, entrepreneurs, and people in general!
.
Subscribe to my newsletter to keep up to date on latest design/tech trends, update, tools and information! 🔥
.
.
👉 Follow me on Twitter and LinkedIn for more content.

[EdgeCodeStudioUK]

Bro!
You dropped the best video for Framer
Thanks a lot for this tutorial and Hats off to you!

[aswathly]

when I submit the form, google drive url opens stating "you don't have access". What might be the issue? (the input from the user is appended to the sheets)

[Muhammad-glwx]

Great AM design


How can I prevent it from going to another page?

[NuanceWebsites]

This is a very important topic. Can you do more videos on all of the forms and the various ways to interact with the data.

[copaxchannel]

Hey AM design, is there a way to redirect submit to an actual framer page like a "thank-you" page? what should I input instead of return?

[G.GroupInvest]

Thanks for this video, I made it and it works fine .. just a small feedback in Framer, the code editor and the code text looks not like yours in the videp anymore so it could be confusing for some peoples if they are not understanding the coding at all

[WebsitesByAlan]

Do you have the code snippet for the Framer part?

[dukedan]

how about multistep forms how would they work/?

[vladromonuck]

how can we do reverse? from google table to framer cms or something automaticly

[toktogulsatylganov]

Thank you for the clear and straightforward tutorial!
I have a question: are these steps similar when linking to Google Forms?

[PranavPrakash-hrbh]

i dont want to redirect to another url after successful submission, what changes should be madein code?

[matheuswebmkt]

You know if is possible send data from Framer to Active Campaign?

[anastasiiafilenkova]

Thanks! This was more than useful – this saved my project!

Still I have a question if I can to redirect the final page not to page with the text but to some page of my site project, so it would be fancier.

I hope you will find this question interesting and useful for others to explain :)

Have a good day!

[MattToering]

Can we pull UTM parameters into the form? That’s a must for me.

[mssanimation]

what changes should I done when using dropdown and checkerbox?

[patrickmullot]

Great Tutorial! congrats! What about security? How could we make the endpoint more secure to only accept requests from the framer page and not any arbitrary person?

[Michael.design]

Is there a way to do it the other way around.. I use a financial api to retrieve stock data in a google sheet. It’s still a goal of me to present that one day in a beautiful way on a website. But don’t really know where to start? Would it be possible with Framer maybe?

[SiKethil]

loved it. Thank you, i have a problem, when form submited it was open permission to access google drive always. Any wrong with this?

[yourtoken]

Is there any way to fetch data other than "text" fields? like drop-down, tel, etc? since e.parameter records just one type ig

[CandelaNazar]

Hi! Thank you very much! This worked amazing.
I was wondering if there's a way to implement options in this script.
Like for example, asking for the gender of a person, if they could select between a set of options.
Also I would like to know if there's a way to make an input optional. Like if someone doesn't want to add their Name, if they could leave it blank without framer asking for an input.
Thank you so much