Google Sheets + Referral Rock

Log new Referral Rock referrals to a Google Sheet

If you need to be able to easily share referral data across teams, adding referrals from Referral Rock to Google Sheets via Zapier is a great solution. It provides enhanced reporting and sharing capabilities for those that may not have direct access to your Referral Rock account.

When this happens...
New Referral
Triggers when a new referral is created.
TriggerInstant
automatically do this!
Create Spreadsheet Row
Create a new row in a specific spreadsheet.
ActionWrite

Try this template

Supported triggers and actions

What does this mean?

New Member
Triggers when a new member signs up.
Trigger
Instant
New Referral
Triggers when a new referral is created.
Trigger
Instant
New Reward
Triggers when a new reward is created.
Trigger
Instant
Updated Member
Triggers when a member is updated.
Trigger
Instant
Updated Referral
Triggers when a referral is updated.
Trigger
Instant

Updated Reward
Triggers when a reward is updated.
Trigger
Instant
Add Member
Add a new member to a referral program.
Action
Write

Add Potential Invite
Adds a new potential invite.
Action
Write

Referral Rock
Adds a new referral from a member.
Scheduled
Action
Referral Rock
Creates a new Referral Action to be used for processing new recurring rewards.
Scheduled
Action
Referral Rock
Update a referral.
Scheduled
Action
Referral Rock
Add email to unsubscribe list.
Scheduled
Action
Referral Rock
Find a member.
Scheduled
Action
Referral Rock
Find a program.
Scheduled
Action
Referral Rock
Find a Referral by Referral ID, Email Address or External ID.
Scheduled
Action
Referral Rock
Find or Add Referral
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