tr Skip to content

Connect Google Sheets and Heartbeat

Use Google Sheets and Heartbeat in the same FlowMattic workflow. Below are the triggers and actions both integrations offer; pick one of each to see how the two connect.

13 triggers 51 actions 1 ready-made template Unlimited runs

Try a pairing

When this happens in Google Sheets6 triggers

Do this in Heartbeat32 actions

1. TriggerNew Spreadsheet Row
2. ActionCreate User

When Google Sheets fires New Spreadsheet Row, FlowMattic runs Create User in Heartbeat with the data from that event.

You build this in the FlowMattic workflow builder on your own site.

Triggers and actions in this pair

A trigger starts a workflow. An action is something FlowMattic does in the app as a step.

Google Sheets app icon

Google Sheets

Integration page

Triggers (6)

  • New Spreadsheet RowTrigger when a new row is added to the spreadsheet
  • New Or Updated Spreadsheet RowTrigger when a row is updated in the spreadsheet
  • Deleted Spreadsheet RowTrigger when a row is deleted from the spreadsheet
  • Update Cell DataTrigger when any cell is updated in the spreadsheet
  • Update Specific Cell DataTrigger when a specific cell is updated in the spreadsheet
  • Update Specific Column ValueTrigger when a specific column value is updated in the spreadsheet

Actions (19)

  • Add New RowAdd a new row with mapped data
  • Update RowUpdate existing row in specific spreadsheet with mapped data
  • Delete RowDelete row by ID in specific spreadsheet
  • Clear Row DataClear data or row by ID in specific spreadsheet
  • Lookup Row DataSearch for data in specific spreadsheet
  • Get Cell DataGet data for particular cell in specific spreadsheet
  • Update Cell DataUpdate data for particular cell in specific spreadsheet
  • Get Row CountGet total number of rows in specific spreadsheet
  • Get Row DataGet rows data from the sheet based on specified range
  • Create Spreadsheet ColumnCreate a new column in specific spreadsheet
  • Create New SheetCreate a new sheet in specific spreadsheet
  • Import CSV or JSON to Existing SheetImport CSV or JSON data to existing sheet in specific spreadsheet
  • Copy SheetCopy a sheet to another or within the same spreadsheet
  • Get RowsRetrieve rows in JSON format for use with Iterator
  • Export sheet to CSVExport the selected sheet to CSV format and save to WordPress Media Library
  • Export Sheet to ExcelExport the spreadsheet to Excel (.xlsx) format and save to WordPress Media Library
  • Export Sheet to PDFExport the spreadsheet to PDF format and save to WordPress Media Library
  • Export Sheet to OpenDocumentExport the spreadsheet to OpenDocument (.ods) format and save to WordPress Media Library
  • Export Sheet to TSVExport the selected sheet to TSV format and save to WordPress Media Library
Heartbeat app icon

Heartbeat

Integration page

Triggers (7)

  • New UserTriggers when a new user joins the community.
  • New or Updated UserTriggers when a new user joins the community or an existing user's information is updated.
  • New EventTriggers when a new event is created in your community.
  • New Event RSVPTriggers when someone RSVPs to an event.
  • New ThreadTriggers when a new thread is created.
  • Course CompletedTriggers when a user completes a course.
  • On Group JoinTriggers when a user joins a group.

Actions (32)

  • Create UserCreate a new user in your community.
  • Update UserUpdate an existing user in your community.
  • Find UserFind a user by email address.
  • Find User By IDFind a user by their unique ID.
  • Deactivate UserDeactivate a user in your community.
  • Reactivate UserRestore access for a deactivated user.
  • Create GroupCreate a new group in your community.
  • Find Group by IDFind a group by its unique ID.
  • Add to GroupAdd one or more users to a group.
  • Remove from GroupRemove one or more users from a group.
  • Create ChannelCreate a new channel in your community.
  • Create ThreadPost a new thread in a channel.
  • Create CommentAdd a comment to a thread.
  • Send Direct MessageSend a direct message to a user.
  • Create EventCreate a new event in your community.
  • Create New InvitationGenerate a new invitation link.
  • Send Invitation to UsersSend an invitation link to users by email.
  • List RolesGet all roles in your community.
  • Get All UsersGet all users in your community.
  • Update ChannelUpdate an existing channel.
  • Delete ChannelPermanently delete a channel.
  • Get ChannelGet a single channel by ID.
  • Get All ChannelsGet all channels in your community.
  • Get Channel ThreadsGet threads from a channel.
  • Get All EventsGet all events in your community.
  • Get All GroupsGet all groups in your community.
  • Get All CoursesGet all courses in your community.
  • Get All InvitationsGet all invitation links.
  • Get DocumentGet a single document by ID.
  • Get All DocumentsGet a paginated list of documents.
  • Get All Channel CategoriesGet all channel categories.
  • Deactivate User (Legacy)Deactivate a user from the community.

Start automating Google Sheets and Heartbeat

Install FlowMattic, connect both accounts and import a template. Every run stays on your own server.

30-day money-back guarantee Unlimited workflows and runs Self-hosted

Google Sheets integration 2.2.4, Heartbeat integration 1.0.0.

Customers who run it every day

Rated 4.8 out of 5 by customers
Read more reviews

No additional usage fees over and above the annual fee ... AND Technical Support is great... they get back to you quite quickly and go above and beyond what is expected...

Verified User in Consumer Goods

Crafting bridges between my favorite apps, FlowMattic has truly impressed me with its ability to seamlessly automate workflows. This has noticeably accelerated the efficiency of my business processes, making everything run more smoothly and productively.