App Holder
Google Sheets

Google Sheets and Microsoft SharePoint Integration

Manage documents and send notifications on new content automatically.Create new rows in Google Sheets. Do much more by connecting Google Sheets and Microsoft SharePoint.

Get Started

Popular Integrations

Microsoft SharePoint - New Task Google Sheets - Add Row

Turn new tasks in Microsoft SharePoint to rows in Google Sheets

Sometimes you need to keep a running record of tasks to share with teammates who don’t have access to Microsoft SharePoint. Google Sheets can easily fill that void for you. But are you going to manually copy and paste each task from SharePoint to a Google spreadsheet? Not if you use this readymade Microsoft SharePoint to Google Sheets integration template.

With this integration activated, every time there is a new task on SharePoint, a new row will be added to your Google spreadsheet with the task details. And, depending on the columns in your Google spreadsheet, you can map fields such as Task Title, Task Due Date, Task Priority, etc. to your sheet.

Simply connect your Microsoft SharePoint and Google Sheets to Automate.io, map the fields you want and turn on the integration.

How it works

  • Step 1:

    This Bot runs whenever there is a new task in Microsoft SharePoint.

  • Step 2:

    Automate.io takes those task details and adds them to a new row on your Google spreadsheet.

Read More
Microsoft SharePoint - New Task Google Sheets - Add a Row

Add a Row in Google Sheets on a New Task in Microsoft SharePoint

Microsoft SharePoint - New Document Google Sheets - Add a Row

Add a Row in Google Sheets on a New Document in Microsoft SharePoint

Google Sheets - New Row (old) Microsoft SharePoint - Send Group Email

Send Group Email in Microsoft SharePoint on a New Row (old) in Google Sheets

Google Sheets - New Row (old) Microsoft SharePoint - Add a Task

Add a Task in Microsoft SharePoint on a New Row (old) in Google Sheets

Google Sheets - New Row Microsoft SharePoint - Add a Task

Add a Task in Microsoft SharePoint on a New Row in Google Sheets

Google Sheets - New Row Microsoft SharePoint - Send Group Email

Send Group Email in Microsoft SharePoint on a New Row in Google Sheets

Microsoft SharePoint - New Task Google Sheets - Update a Row

Update a Row in Google Sheets on a New Task in Microsoft SharePoint

Looking for something else?


Create your own Integration

Connect Google Sheets and Microsoft SharePoint the way you want. Start by selecting the trigger and action events listed here.

When This Happens

TRIGGERS
  • Google Sheets - New Row

    New Row

    Triggers when a new row is added in a worksheet (recommended)
  • Google Sheets - New or Updated Row

    New or Updated Row

    Triggers when a new Row is added or an existing Row is updated
  • Google Sheets - New Spreadsheet

    New Spreadsheet

    Triggers when a Spreadsheet is created
  • Google Sheets - New Worksheet

    New Worksheet

    Triggers when a Worksheet is created
  • Google Sheets - New Row (old version)

    New Row (old version)

    Triggers when a new row is added in a worksheet
  • Microsoft SharePoint - New Document

    New Document

    Triggers when a new Document is added to the selected Site's Document Library
  • Microsoft SharePoint - New Task

    New Task

    Triggers when a new Task is added to a particular Plan. Requires Admin Consent
  • Microsoft SharePoint - New Calendar Event for Group

    New Calendar Event for Group

    Triggers when a new Event is added to the Group Calendar. Requires Admin Consent
  • Microsoft SharePoint - New Group Email

    New Group Email

    Triggers when a new group email is received. Requires Admin Consent

Do this

ACTIONS
  • Microsoft SharePoint - Add a Task

    Add a Task

    Add a Task to a Bucket in Plan. Requires Admin Consent
  • Microsoft SharePoint - Send Group Email

    Send Group Email

    Send an email to a group for a site. Requires Admin Consent
  • Microsoft SharePoint - Add an Event to Group Calendar

    Add an Event to Group Calendar

    Add an Event to the selected Group Calendar. Requires Admin Consent
  • Microsoft SharePoint - Move a Task

    Move a Task

    Move a Task to the specified Bucket in a Plan. Requires Admin Consent
  • Microsoft SharePoint - Search Documents

    Search Documents

    Search Documents based on the Document ID or Document Name. Searches on Document Name look for case insensitive exact matches
  • Microsoft SharePoint - Search Sites

    Search Sites

    Search Sites based on the Site ID or Site Name. Searches on Site Name look for case insensitive exact matches
  • Google Sheets - Add Row

    Add Row

    Adds a new Row. Use this only if you have an issue with the other ‘Add Row’ action.
  • Google Sheets - Add a Worksheet

    Add a Worksheet

    Adds a new Worksheet to a given Spreadsheet
  • Google Sheets - Search Rows

    Search Rows

    Searches a row based on column value
  • Google Sheets - Update a Row

    Update a Row

    Update a row in a given Worksheet based on row id
  • Google Sheets - Add Row (older version)

    Add Row (older version)

    Adds a new row to a given Worksheet
  • Google Sheets - Delete a Row

    Delete a Row

    Delete a Row from the specified Worksheet based on the Row ID

Let's Integrate

Create your custom integration by selecting the Trigger event and Action to be performed.

Run Workflows

Typeform
Facebook Lead Ads
Wufoo

Forms

Google Sheets Workflow
Microsoft SharePoint Workflow
Twitter
Facebook
Facebook Pages

Social

Connect Google Sheets and Microsoft SharePoint with your other apps and run workflows across them. Trigger workflows automatically when things happen in any of the apps.

Try Now

Why Automate.io?

Easy

No coding. No change in your apps. Setup and get going in 2 minutes.

Secure

Runs on secure HTTPS channel & all sensitive data is stored in an encrypted format.

Reliable

Used by 1000+ organizations globally - big and small. Live chat support available.

Automate Work. Have Fun!

Say Goodbye to those busy days

Get Started for FREE

No credit card required.