Needing Google Form Files to be automatically synced with my cms collection for automatic archive updating whenever someone adds their submisssion

I’m having trouble with
I am working on an archive project. part of the project is to get as many people as I can to add their records to the archives. currently I am just manually importing the data into the cms collection on a daily basis. but it’s becoming too hard to keep up with the demand. people are wanting to see their records added to the project as soon as possible and I’m just one guy. how can I go about connecting my cms data with my google form data so that the archive can updated automatically.

So to put it simply, you want the data that is submitted on your google form added automatically to your CMS? Yes, this can be achieved using code.

You will need to write code for a Google Apps Script that will fire every time a person submits data using your google form, and you’ll also need to write Velo code on your site’s backend that fetches this info passed by the Apps Script to your site through an API endpoint and then you can have your Velo code automatically insert this data into your CMS database.

1 Like