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.
Thanks,
Monique
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
Jeff Arnold, President
4Spot Marketing
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
Webforms can use Javascript (JS) but then the JS would have to be able to “talk” to code on a server that made the request for information. Now you’d be getting into cross server issues that JS does not normally allow. So to do what you’ve described would likely be best accomplished on a self hosted webpage that makes these calls to code on the same server and connects with your Infusionsoft account.