With a Zapier integration, you can integrate Google Forms into Fountain.
Third-Party Provider
Please note that the instructions in this article pertain to a third party provider and as such may not reflect all current settings. Should you have any questions or issues, please contact the third party provider directly.
Set up Google Form
Log in to your Google account and build your Google Form. The Google Form must have certain entries. The name, email, and phone number must be collected in the following ways documented in the table below.
Submit a test response. You should see a 1 next to the Responses tab on the top of the Google Form. Click into the Responses tab and click the green sheets icon on the top right.
Select Create a new spreadsheet and name your spreadsheet. Click Create.
| Name | Phone Number | |
Type of Field | Short Text Entry Field | Email Entry Field | Number Entry Field |
Correct Notation | 1. Name 2. First Name and Last Name | Phone Number | |
Incorrect Notation | Full name, your name, etc. | Email address, what is your email, etc. | Phone, mobile phone, digits, etc. |
Set up Zapier Integration
Click Login to Accept Invite. Log in.
Click OnboardIQ on the left column.
Select Google Forms as your Trigger App instead of OnboardIQ. If necessary, search Google Forms in the search bar.
Select New Response in Spreadsheet, then click Save + Continue.
Click Connect an Account, and sign in to the Google account you used to make this form. Enter your password and click Next and Allow. Click Save + Continue.
Now, you will connect your spreadsheet. Choose the spreadsheet that is connected to the Google Form built earlier. For Worksheet, click on Form Responses 1. Do not change anything in Trigger Column. Click Continue.
Zapier should now show something like this. Click Continue.
Click + Add a Step on the left column. Click Action/Search.
Click OnboardIQ. If you can't find it, search "OnboardIQ" in the search bar. It should look something like this:
Select Create Applicant. Click Save + Continue.
Click Connect an Account.
Navigate back to Fountain. Click your initials icon in the top right then Company Settings in the dropdown.
Cilck API under Developer Settings.
Click the blue Show API Keys and copy the Private API Token.
Paste it into Zapier.
Click Yes, Continue.
You will now see Set up OnboardIQ Applicant.
Select which Position you want this data to be imported to within Fountain. Click the paragraph plus icon beside each of the questions and match them to the corresponding question on the Google Form. For questions other than name, email, and phone number, under Data, fill in the data key on the left column and match the question to the key. Repeat for secure data.
Click Continue.
Click Send Test to OnboardIQ. Check your applicant table for this test account's information. When confirmed, click Finish.
Turn on your Zap, and you're set!