> ## 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/e91b0171e12fb000/e2d670f6-26f8-4a81-90d0-e32fc4_1m2a978.png)  
  
Then press 'add automation'  
  
![](https://storage.crisp.chat/users/helpdesk/website/7cfbf57905d70c00/46eacc4a-ff8a-44bf-8592-ed0f80_r76sma.png)  
  
Select loyalty card.  
  
![](https://storage.crisp.chat/users/helpdesk/website/1ccb61507b564300/a9c23572-5f5a-4f7b-b6ba-d4c3a0_1d369k4.png)  
  
The campaign selector opens. Select the loyalty card you want to transfer data from. Hit proceed.  
  
![](https://storage.crisp.chat/users/helpdesk/website/c8944cd6ea700000/9ce8da14-e7bb-4d33-9b21-e6ef11_j8fhlp.png)  
  
The flow automation creator opens. Click on 'customer action'.  
  
![](https://storage.crisp.chat/users/helpdesk/website/2f8c4c852455ba00/d7389041-50b7-4fe8-a7cc-999068_1613gqs.png)  
  
Then select 'loyalty card registration'.  
  
![](https://storage.crisp.chat/users/helpdesk/website/5e15504913fa6800/d604699b-b81f-45cd-8bf8-294771_1jrv5zo.png)  
  
Now select 'webhook'.  
  
![](https://storage.crisp.chat/users/helpdesk/website/c2b3e8e7f6daa800/424213cb-daa6-4001-8bf1-c1beb0_vuktg3.png)  
  
Press on the red text 'webhook' to set one up.  
  
![](https://storage.crisp.chat/users/helpdesk/website/c66de92e036fd800/dd94b17f-aa1b-4634-8635-03cdb8_wprtvf.png)  
  
Now let's first get a 'webhook by zapier' webhook. Go to this web page: [https://zapier.com/apps/webhook/integrations](https://zapier.com/apps/webhook/integrations) . Then select the first option 'Google Sheets'.  
  
![](https://storage.crisp.chat/users/helpdesk/website/4f195bb9b9f2ec00/1a9f2132-181f-4c31-90bb-943abe_1q0qjl8.png)  
  
Now select 'Add info to Google Sheet from a new webhook POST request'.  
  
![](https://storage.crisp.chat/users/helpdesk/website/d3eb8c2708a5f800/0ab5dea6-9c53-43b5-bc72-665586_1u0t78r.png)  
  
Copy the 'catch hook'.  
  
![](https://storage.crisp.chat/users/helpdesk/website/1ef64acd38ec1500/793c93cb-85c0-484d-baad-6d60f5_1ln20ht.png)  
  
Go back to your builder and paste the catch hook in the window.  
  
![](https://storage.crisp.chat/users/helpdesk/website/dec5d976f8e6c800/e9e15663-be34-4220-841b-b87312_1913in8.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/427d329f4d0ce400/2af92104-a557-472b-8d85-396e74_11agtbz.png)  
  
Go back to the Zapier page and press on 'continue'.  
  
![](https://storage.crisp.chat/users/helpdesk/website/4e48e84a02084000/931aa976-f117-4598-b1ed-02b751_14zj7v5.png)  
  
Let's select the action event. 'Adding rows to a Google Spreadsheet.' Press on continue  
![](https://storage.crisp.chat/users/helpdesk/website/3d90696d14d56400/21f8ddb5-a303-4bb0-a6a6-ff5188_pj81mn.png)  
  
Now select the Google account where the Spreadsheet is located.  
![](https://storage.crisp.chat/users/helpdesk/website/91f91cf590a3d800/24aba6d3-15d3-4663-8e78-572442_1mdfhj.png)  
  
Connect the right spreadsheet to the process.  
![](https://storage.crisp.chat/users/helpdesk/website/ea362dfa9dea2000/743206ec-6e87-4a85-bb92-7b62b4_184tnkm.png)  
  
Connect the right tab of the Spreadsheet to the process.  
![](https://storage.crisp.chat/users/helpdesk/website/64af2d5dd5122000/646be6c7-64d5-4739-8c9b-d9b3f9_1bf44j1.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/6c96d801079cf000/c9baa6d0-1b52-4e44-b3c2-c44e27_43havq.png)  
  
This is how it should look. Hit continue.  
![](https://storage.crisp.chat/users/helpdesk/website/581675c62c845800/c23386fa-77a7-48af-9d1e-c8a17a_15wfokp.png)  
  
Let's run a test and check if the data appears in the spread sheet.  
![](https://storage.crisp.chat/users/helpdesk/website/a0be789a66bc5000/ec7d8240-8a94-49b6-9c49-6d4692_ar2mhu.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/71edc803f64bcc00/39595f5c-012c-48f4-9452-d74ecb_16we4ku.png)