Back
Microsoft SharePoint Create an item in a list. Google Forms New form response.

Create Microsoft SharePoint items from Google Forms responses

Connect

How this automation works

Create Microsoft SharePoint list items automatically from new Google Forms responses. When a new response is received in Google Forms, this Applet adds an item to the Microsoft SharePoint list you choose and sets the column values you provide. It's useful for teams collecting form data with Google Forms who want responses logged in Microsoft SharePoint for reporting, approvals, or recordkeeping.

If
Google Forms icon
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a new form response is received.
FormName FormId ResponseUrl ResponseId RespondentEmail Question1Title Question1Answer Question2Title Question2Answer Question3Title Question3Answer Question4Title Question4Answer Question5Title Question5Answer CreateTime LastSubmittedTime
Then
Microsoft SharePoint icon
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will add a new item to the SharePoint list you choose, setting the column values you provide.
list column_values

Services used in this Applet

Create your own Google Forms and Microsoft SharePoint workflow

Create custom workflows effortlessly by selecting triggers, queries, and actions. With IFTTT, it's simple: “If this” trigger happens, “then that” action follows. Streamline tasks and save time with automated workflows that work for you.

9 triggers, queries, and actions

Item updated in a list

Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when an item in the SharePoint list you choose has the column you're watching change, optionally only when it changes to a specific value.

New file in a document library

Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a new file is added to the SharePoint document library you choose.

New form response

Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a new form response is received.

New item in a list

Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a new item is added to the SharePoint list you choose.

New or updated form response

Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a new form response is received or updated.

Find an item in a list

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns an item from the SharePoint list you choose, matched by a column value.

Create an item in a list

Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will add a new item to the SharePoint list you choose, setting the column values you provide.

Update an item in a list

Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will update the column values of an existing item in the SharePoint list you choose.

Upload a file to a document library

Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will upload a file to the SharePoint document library you choose.

Create an item in a list

Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will add a new item to the SharePoint list you choose, setting the column values you provide.

Find an item in a list

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns an item from the SharePoint list you choose, matched by a column value.

Item updated in a list

Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when an item in the SharePoint list you choose has the column you're watching change, optionally only when it changes to a specific value.

New file in a document library

Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a new file is added to the SharePoint document library you choose.

New form response

Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a new form response is received.

New item in a list

Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a new item is added to the SharePoint list you choose.

New or updated form response

Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a new form response is received or updated.

Update an item in a list

Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will update the column values of an existing item in the SharePoint list you choose.

Upload a file to a document library

Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will upload a file to the SharePoint document library you choose.

Build an automation in seconds!

You can add delays, queries, and more actions in the next step!

More on Google Forms and Microsoft SharePoint

About Google Forms

Google Forms lets you easily create and share online forms and surveys, and analyze responses in real time.

Watch our Google Forms Video

Explore Google Forms

More integrations with Google Forms

About Microsoft SharePoint

SharePoint is Microsoft's content and collaboration platform for organizations. Teams use it to securely store, organize, and share files, build team sites and intranet portals, and manage documents and knowledge in one place. It works alongside the rest of Microsoft 365 — Teams, Word, Excel, and Copilot — so content stays connected to where people already work.

Explore Microsoft SharePoint

IFTTT helps all your apps and devices work better together

Get started for free