Get insights quickly, with Google Forms. Easily create and share online forms and surveys, and analyze responses in real-time.
Go to siteThe Google Forms API lets you programmatically access and manipulate your forms and responses. In Pipedream, integrating Google Forms can automate mundane tasks, sync form data with other services, and trigger actions based on submission events. You can create, edit, and collaborate on forms, and analyze responses in real-time combined with Pipedream's serverless platform to create powerful workflows.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
google_forms: {
type: "app",
app: "google_forms",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://www.googleapis.com/oauth2/v1/userinfo`,
headers: {
Authorization: `Bearer ${this.google_forms.$auth.oauth_access_token}`,
},
})
},
})
Auto-Respond to Form Submissions: Set up a workflow that sends a customized email to the respondent using the Gmail app whenever a new Google Form submission is received. This can provide immediate engagement and confirm receipt of their responses.
Save Submissions to a Spreadsheet: Automatically add new Google Forms responses to a Google Sheets spreadsheet. This workflow streamlines data collection and allows for advanced analysis and reporting capabilities.
Sync to a CRM: On new form submission, use the Pipedream workflow to parse and send the data to a CRM like Salesforce or HubSpot. This keeps your sales or customer service teams updated with fresh leads or inquiries without manual data entry.
Emit a new event when the form is answered. See the documentation
Emit a new event when an answer is sent or updated. See the documentation
Google Forms uses OAuth authentication. When you connect your Google Forms account, Pipedream will open a popup window where you can sign into Google Forms and grant Pipedream permission to connect to your account. Pipedream securely stores and automatically refreshes the OAuth tokens so you can easily authenticate any Google Forms API.
Pipedream requests the following authorization scopes when you connect your account:
email
profile
https://www.googleapis.com/auth/forms.body
https://www.googleapis.com/auth/forms.body.readonly
https://www.googleapis.com/auth/forms.responses.readonly
GET
https://accounts.google.com/o/oauth2/auth
?
client_id={{oauth.client_id}}
&
redirect_uri={{oauth.redirect_uri}}
&
state={{oauth.state}}
&
response_type=code
&
scope={{oauth.space_separated_scopes}}
&
prompt=consent
&
access_type=offline
POST
https://oauth2.googleapis.com/token
content-type: application/x-www-form-urlencoded
accept: application/json
client_id={{oauth.client_id}}
&
client_secret={{oauth.client_secret}}
&
redirect_uri={{oauth.redirect_uri}}
&
grant_type=authorization_code
&
code={{oauth.code}}
POST
https://oauth2.googleapis.com/token
content-type: application/x-www-form-urlencoded
accept: application/json
client_id={{oauth.client_id}}
&
client_secret={{oauth.client_secret}}
&
grant_type=refresh_token
&
refresh_token={{oauth.refresh_token}}