> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.coupontools.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Transfer loyalty card registrations to google spreadsheet via automation flow builder

Using the automation tool, you can easily pass on loyalty card registrations to a Google spreadsheet via Zapier. Follow my lead to set this up.

|| This feature is on request! [Get in touch with the support team](https://www.coupontools.com/en/get-in-touch) to have it enabled for your account!

Once you have access to the feature, you'll find it at integrations (1), flow automation (2). Hit proceed to open the creator.


![](https://storage.crisp.chat/users/helpdesk/website/4c4cc617dc0a0c00/image_1nzqb59.png)

Then press 'add automation' 


![](https://storage.crisp.chat/users/helpdesk/website/4c4cc617dc0a0c00/image_dg7b50.png)

Select loyalty card.

![](https://storage.crisp.chat/users/helpdesk/website/4c4cc617dc0a0c00/loyaltyflowautomation_bmt3xw.png)

The campaign selector opens. Select the loyalty card you want to transfer data from. Hit proceed.

![](https://storage.crisp.chat/users/helpdesk/website/4c4cc617dc0a0c00/selectcardautomation_1mgnw5t.png)

The flow automation creator opens. Click on 'customer action'.

![](https://storage.crisp.chat/users/helpdesk/website/4c4cc617dc0a0c00/presscustomeraction_6pipbp.png)

Then select 'loyalty card registration'.

![](https://storage.crisp.chat/users/helpdesk/website/4c4cc617dc0a0c00/selecttrigger_1xarwjm.png)

Now select 'webhook'.

![](https://storage.crisp.chat/users/helpdesk/website/4c4cc617dc0a0c00/selectwebhook_p1iykg.png)

Press on the red text 'webhook' to set one up.

![](https://storage.crisp.chat/users/helpdesk/website/4c4cc617dc0a0c00/presswebhook_179zlrw.png)

Now let's first get a 'webhook by zapier' webhook. Go to this web page: https://zapier.com/apps/webhook/integrations . Then select the first option 'Google Sheets'.

![](https://storage.crisp.chat/users/helpdesk/website/4c4cc617dc0a0c00/webhooksgooglesheet_18p2sj6.png)

Now select 'Add info to Google Sheet from a new webhook POST request'.

![](https://storage.crisp.chat/users/helpdesk/website/4c4cc617dc0a0c00/addinfotosheet_1gtkj9h.png)

Copy the 'catch hook'.

![](https://storage.crisp.chat/users/helpdesk/website/4c4cc617dc0a0c00/copywebhook_dvuyyq.png)

Go back to your builder and paste the catch hook in the window.

![](https://storage.crisp.chat/users/helpdesk/website/4c4cc617dc0a0c00/pastewebhook_1sn9u36.png)

Create a Google Spreadsheet and set up columns with field names. I'm using First Name, Last Name, Email, Phone number.

![](https://storage.crisp.chat/users/helpdesk/website/4c4cc617dc0a0c00/setuprows-in-spreadsheetpng_wc945c.png)

Go back to the Zapier page and press on 'continue'.

![](https://storage.crisp.chat/users/helpdesk/website/4c4cc617dc0a0c00/continuezap_x4p5dm.png)

Let's select the action event. 'Adding rows to a Google Spreadsheet.' Press on continue
![](https://storage.crisp.chat/users/helpdesk/website/4c4cc617dc0a0c00/selectaction-event_1wxzz5p.png)

Now select the Google account where the Spreadsheet is located.
![](https://storage.crisp.chat/users/helpdesk/website/4c4cc617dc0a0c00/selectaccount_18k6m89.png)

Connect the right spreadsheet to the process.
![](https://storage.crisp.chat/users/helpdesk/website/4c4cc617dc0a0c00/choosevaluezap_1v5zrbc.png)

Connect the right tab of the Spreadsheet to the process.
![](https://storage.crisp.chat/users/helpdesk/website/4c4cc617dc0a0c00/choosetab_208qnm.png)

Now let's synch the values of the registrations of the loyalty cards to the spreadsheet. Press on 'First Name' and link it to the correct value. Repeat this gesture 3 times.
![](https://storage.crisp.chat/users/helpdesk/website/4c4cc617dc0a0c00/connectvalues_obe97u.png)

This is how it should look. Hit continue.
![](https://storage.crisp.chat/users/helpdesk/website/4c4cc617dc0a0c00/hitcontinuepng_motwkl.png)

Let's run a test and check if the data appears in the spread sheet.
![](https://storage.crisp.chat/users/helpdesk/website/4c4cc617dc0a0c00/testcontinue_n23nj9.png)

Now, register yourself on yourself as a user on your loyalty card and check if your data appears as well. Give it some time to appear. I experienced quite a delay, but it will appear if you followed the above-mentioned instructions. This is what my example looks like. The first one is the test, the second one is my registration.


![](https://storage.crisp.chat/users/helpdesk/website/4c4cc617dc0a0c00/image_ivz62b.png)