Easy send and save data from FlutterFlow to Google Sheets table

welcome so we have our project in ferlow and for example we have some data form that we want to receive data from and send this data to Google spread sheet I have very simple SP sheeet here it's a name email and phone uh and I want to save all uh submissions from this form to my Google spreadsheet uh API 4 allow you very easy to connect your photo project with Google Sheets you need to create a new project select Google Sheets as service you'll use and next you need to create Google Sheets connection for example we will use name API flow uh form demo and next we need to go to our Google Sheets document and share it by link and we need to set editor assess level as we will send data to this table now we copy link click done go back to API for paste this link and save our connection so now I will use my API form demo and we'll use contacts uh document sheet I need to choose it to open assess and now I can publish it I also marked as yes option that I have heers throw because I have this row here with labels for every column and now I'm able to p publish my project so I publish it and what we need to do next we need to copy uh to download open IPI definition we click this button and API flow prepare uh open API definition for us now we go to our project in flatter flow API call section and we'll import that open API definition and we have here our contact spreadsheet connected now to flatter flow you can query data you can insert rows and you can uh get contact by index and update contact using this API cods so what we will do now we will map body request to our uh to2 variables to be able to use this action from inside of our uh flutter FL application page so we have three columns uh as you can see they named by uh column letter here in the document and this is a way how API flow us use data input so you have not names or heers here in your document but you have names of them columns this differ from list action because if you will have some data here for example May some [Music] data here and I will query it from okay we forgot to put authorization here actually we need to go and copy terization heer and add it here so our assess will be protected and now we can query data from our spreadsheet so you can see it is selected suppose because I not saved this s yet you can see it is selected with names of our columns but when you work with insert you need to use column names so we will create a variables from for this we will use variable called name here will be typ string called email will also be typ string and uh phone also type string save our work and now we go and put this Fields inter request body so this data will be sent to our Google spreadsheet now we can go and do a test here we will use something [Music] John and phone number you send this request and as you can see we received response and this data save to our Google so what we will do next to actually use this action from our uh flatter flow page we will create ah we don't need data type at the moment we will connect this form with our API address you can use data type for response but it's optional in this case so we have submit form and we will create an action for top on top of this button we will add a new action and we will use backend API call now we need to specify our group Next we need to insert new row in contacts and we need to click sub additional variable we will set name where will use widget State full name additional variable email we'll use youit State email and next is phone youit State phone forone number so now we have all these FS mapped and for example we will call this response and if data saved we will add action now get two success page I created a very simple success page so it will follow us to show to our visitors that his data is sent to S okay so now we have these fields and button connected with our API call and let's test it okay so my application is ready to for test it took little bit longer to load I suppose because huge huge Dam at the moment so we will test it for example I will put some name like visitor mail mail sample com and phone number and submit my phone and my form is submitted and I see screen let's check data yes it's saved to our Google spreadsheet so this is how you can connect your fful project your forms and different screens via API flow project to Google spreadsheet and send and receive your data and work with Google spreadsheet in very smooth easy to manage way thank you for your attention please check other video in our Channel and if you have any question you can let me know in the comment or visit our website api. me and ask any help in the chat thank you and have have a nice day

Channel: ApiFlow

Views: 761

Keywords: flutterflow, flutterflow backend, flutterflow api, flutterflow google sheets, flutterflow sheets, flutterflow sheets integration, google sheets integration, flutterflow save data, flutterflow table, flutterflow sheets api, flutterflow integration, flutter google sheets api

Id: sWJRk5db6N0

Length: 10min 3sec (603 seconds)

Published: Tue Mar 05 2024