Posted by João Martins on 13 Apr 2026
How to Send Form Data to Google Sheets with Python
Forward your Flask form submissions to Google Sheets using Form2Sheet
If you're building a Python web app with Flask, you can store form submissions in Google Sheets without setting up a database. Form2Sheet handles everything — just forward the data and you're done.
Step 1: Prerequisites
The first step in integrating Form2Sheet is to subscribe either monthly or yearly.
Then, go to https://form2sheet.com and create your first
spreadsheet.
(Email received after creating a spreadsheet)
Step 2: Building Your Python Form Handler
Set up a Flask route that receives form submissions and forwards them to Form2Sheet using the requests library. Make sure to replace the $API_URL with the one you received
in your email (check your spam folder as well).
from flask import Flask, request, redirect
import requests
app = Flask(__name__)
@app.route('/submit', methods=['POST'])
def submit_form():
form_data = {
'name': request.form['name'],
'email': request.form['email'],
'message': request.form['message']
}
requests.post('', data=form_data)
return redirect('/thanks.html')
if __name__ == '__main__':
app.run(debug=True)
Step 3: Submitting the Form
In the GIF below, you can see how after submitting the form you check the results in
your Spreadsheet.
Besides that, you and the respondent will receive a confirmation email with the data
submitted.
And that's is! Simple as that. Aditionally, you can create Unlimited Spreadsheets, customize the Thank You page, add as many Custom Form Fields as you want and remove the Form2Sheet branding from the emails.
Conclusion
Congratulations! You can now go ahead and publish your custom form. It is now
ready to start collecting responses. With
Form2Sheet, the process is streamlined, and you can focus on obtaining valuable data
without
the hassle of complicated setups.
If this made you curious, go ahead and check our pricing below.
