Skip to main content

Giftbit + Google Sheets

Send rewards automatically using Google Sheets, no code needed

How to trigger rewards from Google Sheets

This tutorial is to set up annual automated rewards for anniversary rewards, but the functionality can be used for any use case.

Screenshot of Giftbit and Google Sheets zap in setup in Zapier

How to set up a reward triggered by Google Sheets

Use these simple tools to automate reward sending. 

 
right-arrow_ink-principle

Set the trigger

In Zapier, choose Google Sheets as the trigger app.

Select New row added as the event.

Log into Google and select the sheet you want to trigger from.

right-arrow_ink-principle

Date set and delay

Since each hire date is in the past, reformatting is required in order to function for a future send date.

In Zapier, choose Formatter by Zapier and choose Date/Time.

Connect the (MM/DD) fields.

Select Delay Until event.

right-arrow_ink-principle

Set the action

In the Action step choose Giftbit and Send Reward

Log into Giftbit and select your template and map the email and name fields.

right-arrow_ink-principle

Test and activate

Test your Zap to check if the automation works correctly. Zapier will show you the results in real-time.

One you're satisfied with the test, activate your Zap and watch your reviews pile up.

Rewards work.

Achieve more with digital incentives.