Is it possible to use a Google Sheet API on a Jotform ?

I want to create a Jotform that will check to see if an email address exists in a list that is maintained in a Google Sheet.

I am able to create an Google Sheet API that can be called via a URL with the Email address that is to be checked. The API can be designed to return a "TRUE" or "FALSE" or any other value that Jotform can accept.

I am hoping I could have a field on the Jotform that is entered with an email address and then a button that says validate.

After clicking the button the value will be returned to a field on the Form that will be "TRUE" if the email address is valid and then other fields on the form are enabled for entry....or if "FALSE" is returned a message is displayed indicating the email is invalid.

So is it possible to configure a Jotform to perform this type of process and what components do I put on the Jotform to achieve it.

Thanks

Hi,

I am hoping I could have a field on the Jotform that is entered with an email address and then a button that says validate.

Unfortunately, we don't have that type of button to validate an email address. However, we have an email validator widget that can verify the email address through a 2 step verification process. Based on your workflow, I think you are looking for a similar function the only thing is that you are using an existing list or to look up for the email in Google Spreadsheet, correct?

I think there's a workaround though we only have a button and its functionality is to submit the form, why not using the submit button as an alternative to verify the email. Then, set up the Thank You page to redirect your form users to a second form wherein your API will return the value to your form and will hide/show the form fields based on a condition: Hide-or-Show-Multiple-Fields-at-Once

I hope this helps.