Connect Sharepoint and Google Sheets

Connect SharePoint and Google Sheets to automatically log document activity, track approvals, and generate live reports.

With Activepieces, every new file upload, update, or list change in SharePoint can update a Google Sheet instantly, helping your team maintain visibility and organization without manual data entry.

When a new file is uploaded to a SharePoint library, Activepieces adds a row in Google Sheets with the file name, uploader, and upload date.

When a file is updated or renamed, Google Sheets logs the change with timestamps and version details.

When a new list item is added in SharePoint, Activepieces updates your Google Sheet with the item’s name, status, and owner.

When a document is approved, the Google Sheet automatically marks it as “Approved” and adds the approver’s name.

When a folder is created in SharePoint, Activepieces logs its name, path, and creation date in Google Sheets for structured tracking.

When a file is deleted or moved, Google Sheets marks its status as “Archived” or “Removed” for easy audit management.

Automate Data Tracking and Documentation

With Activepieces, SharePoint and Google Sheets work together to turn your file and workflow data into actionable insights. Automatically record document uploads, status changes, and list updates for effortless tracking.

Simplify Reporting and Workflow Transparency

Activepieces keeps your reporting workflows consistent and up to date. You can generate live dashboards in Google Sheets based on SharePoint activity, ensuring teams always have access to the latest document and project information.

Reliable, Secure, and Fully Configurable

All SharePoint-Google Sheets automations through Activepieces use encrypted, authenticated APIs. You can customize which libraries or lists trigger actions, define the data structure for Google Sheets, and apply filters for precise reporting.