Help with Google Forms sync

Brian_Curtis

Hi All,

I am trying to create a procurement Smartsheet for my company, using Google Forms as a method of collecting data for procurement requests.  The reason I am using Google Forms is that it has form logic, which is something the people at Smartsheets have not implemented yet, but are working on from what I am being told.  I was able to get the Google Form to sync with my Smartsheet account, however, in order for the form to work, it has to create a new Smartsheet.  Ideally, I would like to have the form feed into a procurement Smartsheet that I have already created, added automation, and formatting.  If not, is it possible to feed the data collected from the Google Form's new Smartsheet, into my existing procurement Smartsheet?  If neither of those is possible, the only other option I see is to copy and paste what I can from the existing procurement Smartsheet. 

Andrée Starå

Hi Brian,

Unfortunately, as far as I know, it's not possible at the moment to select another sheet to sync the Google Forms submissions to, but it's a great idea!

Please submit an Enhancement Request when you have a moment.

As a possible workaround, you could use a third-party service like Zapier to copy the submitted information to the other sheet.

Would that help/work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting