Google Sheets + Participate

Update and lookup spreadsheet rows in Google Sheets for new updated Participate courseworks

Easily track up-to-date course progress for your Participate learners with this integration. Once it's active, this automation records course progress and completion for each learner as they move through your Participate courses, automatically saving and updating those details by updating rows in a specified Google Sheets spreadsheet.

When this happens...
Updated Coursework
Triggers when a user updates coursework.
TriggerInstant
automatically do this...
Lookup Spreadsheet Row
Finds a row by a column and value. Returns the entire row if one is found.
ActionSearch
then do this!
Update Spreadsheet Row
Update a row in a specific spreadsheet.
ActionWrite

Try this template

Supported triggers and actions

What does this mean?

New Course Bundle Enrollment
Triggers when a user enrolls in a course bundle.
Trigger
Instant
New Community Member
Triggers when a user joins a community.
Trigger
Instant
Leaving Community Member
Triggers when a user leaves a community.
Trigger
Instant
Updated Coursework
Triggers when a user updates coursework.
Trigger
Instant
Course Chapter View
Triggers when a user views a course chapter
Trigger
Instant

New Course Enrollment
Triggers when a user enrolls in a course.
Trigger
Instant
Add a User to a Group
Adds a user to a group
Action
Write

Create Community Invitation
Sends email inviting a user to a community.
Action
Write

Participate
Sends email inviting a user to a group
Scheduled
Action
Google Sheets
Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.
Scheduled
Trigger
Google Sheets
Triggered when a new row is added to the bottom of a spreadsheet.
Instant
Trigger
Google Sheets
Triggered when you create a new spreadsheet.
Scheduled
Trigger
Google Sheets
Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.
Scheduled
Trigger
Google Sheets
Triggered when a new row is added or modified in a spreadsheet.
Instant
Trigger
Google Sheets
Triggered when you create a new worksheet in a spreadsheet.
Scheduled
Trigger
Google Sheets
Create a new column in a specific spreadsheet.
Scheduled
Action
Google Sheets
Create a new row in a specific spreadsheet.
Scheduled
Action
Google Sheets
Create one or more new rows in a specific spreadsheet (with line item support).
Scheduled
Action
Google Sheets
Create a new worksheet by copying an existing worksheet.
Scheduled
Action
Google Sheets
Create a blank spreadsheet or duplicate an existing spreadsheet. Optionally, provide headers.
Scheduled
Action
Google Sheets
Create a blank worksheet with a title. Optionally, provide headers.
Scheduled
Action
Google Sheets
Deletes the content of a row in a specific spreadsheet. Deleted rows will appear as blank rows in your spreadsheet. Please use with caution.
Scheduled
Action
Google Sheets
Update a row in a specific spreadsheet.
Scheduled
Action
Google Sheets
Finds many matched rows (10 max.) by a column and value.
Scheduled
Action
Google Sheets
Returns many rows (20 max.) as a single JSON value and flat rows (line items).
Scheduled
Action
Google Sheets
Finds a row by a column and value. Returns the entire row if one is found.
Scheduled
Action
Google Sheets
Finds or creates a specific lookup row.
Scheduled
Action

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn more

Related categories

Similar apps

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

Quip

Documents

About Participate

Participate is a team collaboration app that combines your favorite parts of social media and online learning in Communities of Practice (CoPs) that inspire professional learning, connection and growth.

Related categories

Team Collaboration

Get started for free

You can't add more hours to the day. Zapier is the next best thing.

By signing up, you agree to Zapier's terms of service and privacy policy.