Want to try this workflow? Click on the Zap template to get started. Plus, keep reading for more details on how to set up this Zap in the video transcript below.
Send prompts to OpenAI for Google Forms responses and add the OpenAI response to a Google Sheet
This workflow requires a multi-step Zap, available on a paid Zapier plan or during a free trial. Learn more about multi-step Zaps.
What I want to do today is connect our Google Forms app to OpenAI so that whenever a form response is received, a prompt is automatically sent to OpenAI with the response added to a spreadsheet. Let's dive in.
New to Zapier? It's workflow automation software that lets you focus on what matters. Combine user interfaces, data tables, and logic with 6,000+ apps to build and automate anything you can imagine. Sign up for free.
In order to get started with this workflow, I need to create a Zap by clicking the Create Zap button on the left-hand side of the screen.
Because I want Google Forms to trigger a prompt in OpenAI, I'll need to use Google Forms as my trigger. I can find the app by typing it inside the search bar and clicking below.
The trigger screen will then pop up. I should click New Form Response as my event, and then click Continue.
Setting this as the trigger means that anytime Google Form sees an email is sent to our inbox, it's going to run this workflow.
The first time we set up Google Forms, we'll need to authenticate it with Zapier. A link will pop up for you to log into your Google account. Don't worry, it's totally safe because Zapier uses industry standards for encryption when connecting with each of your apps.
We'll then need to fill out our trigger apps data. To do that, select the form you like to use for your Zap and click Continue.
In order to finish setting up the trigger, we'll need to pull in some example data. To do that, click Test trigger. You're all set with the first step. Click Continue, and we can start creating our first action.
Type OpenAI into the search bar and select it from the dropdown menu. Next, click Send Prompt, and click Continue.
From there, I can select our account and authenticate OpenAI with Zapier, just like I did with my Google account. To do this, go to your OpenAI page, click the top-right account button on your screen, and then select View API Keys in the menu. Click Create New Secret Key, and then copy and paste it onto your authorization screen.
By the way, if at any point you get stuck, Zapier's got an amazing support team that can help you out.
For this specific workflow, click Continue and it's time to assign our trigger apps data into the action apps fields.
Under Prompts, I'll type in a custom message. I'll type "Please answer the following questions," and then I'll select Question from the dropdown. I'll then click Continue.
Tip: To get the best results, write a clear prompt with sufficient context. Need help refining your text query? Here are six tips to help you write an effective prompt.
Click Test action, and we can move on to our second action step.
Click the + button on the bottom of the screen to get started. OpenAI will answer our questions, but we'll need a place to send our answers to. Let's use Google Sheets. Type in Google Sheets into the search bar, and then select Create Spreadsheet Row, and then click Continue.
Log into your account once more and click Continue again. From there, we can assign our trigger apps data into the action apps fields. First, select the spreadsheet worksheet you'd like to use for your Zap. Once that's complete, the data from my spreadsheet will appear. Under Question, I'll select Question, and then under Prompt, I'll select Response from the dropdown and click Continue.
Note: At the time this video was recorded, "Response" was previously "Choices Text."
Click Test action, and I should be all set. This is ready to turn on.
Now, whenever a new form is created, a spreadsheet response will automatically be created by OpenAI. Want to try it yourself? Click on the Zap template below to get started.
