I need to create a webform or internal form that can pull from a Google Sheet with the most current Names and addresses of a business. We need the ability to choose 5 locations from the webform/internal form. Then send an email to the locations they chose. Can this be done through Zapier or does it require an API? Currently, we have entered all of them but it is too cumbersome to scroll through and choose from 400.
Web forms and Internal Forms are not dynamic – meaning that the fields that are in those forms cannot be changed based on data feeding from somewhere else.
Zapier can grab data from a Google Sheet, but unfortunately it wouldn’t dynamically populate a web/internal form.
If you were doing API, you could have a web-based form created based on the API call to the Google Sheet and then drive automation from there.
Hope that helps.
Jeff Arnold, President
Infusionsoft Certified Partner
PlusThis Certified Partner
Zapier Certified Expert
4Spot Marketing • 4SpotMarketing.com
11700 W Charleston #170-160 • Las Vegas • NV • 89135
O: 702-721-9763 • C: 702-525-9763
Client Testimonials • Book an Appointment