> For the complete documentation index, see [llms.txt](https://docs.gamifyroute.com/kb/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.gamifyroute.com/kb/campaign-details/integrations/google-sheet.md).

# Google Sheet

Sometimes the campaign manager wants their campaign data in Excel format to be processed further. For this to be achieved, Gamify Route provides Google Sheets integration. Once you setup it successfully, every time the end user plays a game, you will have entries in your Google Sheet.

{% embed url="<https://youtu.be/Kk6F7e-FTdg?feature=shared>" %}
Google Sheet Integration with Gamify Route
{% endembed %}

Follow the below steps to integrate your Google Sheet:

* On the campaigns screen, on your campaign, go to ‘Details’

<figure><img src="https://lh7-us.googleusercontent.com/wuf4RIAt3oQaxthT-Io6McT-HwJyTteKlo35deyhPwM65SVPghlEHICGg-9ztZmsYAcl6DzpTz-kcymc6nzIK3pINwRAQZ8H7n-9hZlgeVYps9N_anRuTH1WhZL2eNqS2R-g0mqSkrdFfgoZdFYhp9k" alt=""><figcaption></figcaption></figure>

* Go to ‘Integration’ tab

<figure><img src="https://lh7-us.googleusercontent.com/ntHJmZfU8QG0akPGuDgHYWuvAsdLpu0WOg-rAlPw3LsyS68VIGQ_4LjrShSO8lFB7LZiD4a2znlJXaMVnRi_3tkB-24fK9PBFcSwTjzx7y7c6CE_FWoklqLn8YfrhLLXWNAX7buwbrRr4lniJi-lSO0" alt=""><figcaption></figcaption></figure>

* Click on the ‘Connect’ button on the Google Sheet block

<figure><img src="https://lh7-us.googleusercontent.com/-j7DmYav4mYm95UA5vvuzGt8s0MefSYq1YbpibKV10jYn_xQqXIe9mfXeR4imFgkQ7nyaUN__8KmDziMxcOWSA2zjFbKcnN6udqLA77q8pNjZLRvdz8YTwisdS5fWAhQSJsnBfFcu0aFOsuCpiMU8ys" alt=""><figcaption></figcaption></figure>

* Click on 'Sign in with Google' button

<figure><img src="/files/mKAcK9YcJxULKCXw55gS" alt=""><figcaption></figcaption></figure>

* A new window will open, and you might need to select the email associated with your spreadsheet account. Click on the Continue button.

<figure><img src="/files/X8sx1AIoofbzv69J1qa5" alt=""><figcaption></figcaption></figure>

* Copy the access token

<figure><img src="https://lh7-us.googleusercontent.com/Vd0dwAYMavDItzMP9fqvbYpWDd6nJZ0PpfkY_xxSbJHHzsWhgfvuwE2G-GAid4TuNwQ0mTGKrPOkW73MRKcaGCBkiNSqrIYQHBF39TRvN0GDXOzBt1pAEDzx8UqSCBr3Eq0MhdwxuF_Q-xFobYvXrhw" alt=""><figcaption></figcaption></figure>

* Paste the code and click on the ‘Save Setting’ button

<figure><img src="https://lh7-us.googleusercontent.com/okjoWhDafZRNopvctgQ6bAKrmlLXAOmc0ZJcfYDK5CQ5_kEmSpFwzjvkSPIlM5I95nLuv5JpqeBWopwo-HJ5A89e9hrQOg2F1RV7a7KWqz59xCq4RrQ9nfIkq8OYv8dA6Cd98t2uRQSAqOKb6LGViVI" alt=""><figcaption></figcaption></figure>

* Click on the ‘Configuration’ button in Opt-in block

<figure><img src="https://lh7-us.googleusercontent.com/ujqRIq8qUrxht1JgquKLAHjp2-mNntsGyKrjhhcpRaxrv0lIM4ljGAS7-LLvaLM7T0o261L9SlIa7L_atcH4zdMvd3zijRdYrzVk7sBsH6bSskF2y5Av8SJi0Gza7QNJCny--bhkwZy-OhcWF_MFSG4" alt=""><figcaption></figcaption></figure>

* Enter details, map your fields in opt-in form, enable it for syncing and click on the ‘Save’ button

<figure><img src="https://lh7-us.googleusercontent.com/dK9Utyrgxi_CGdFP8kjeDacGlgUqcO5uXQ1b1qqphgPOwL9DUV0B8YcHyqJlljoBkAtAoGy5TfGIHQnTvxbtb33aJ3vvlmLEog8hzC1_0wa7A64zolni9jnfodqot-ohrQcWXflh8Slg1mzbT4rYUzg" alt=""><figcaption></figcaption></figure>

* Repeat steps for claim form and campaign all data
* Once you successfully setup, you will have status active beside all three blocks. And in your Google Sheet, you will have headers

<figure><img src="https://lh7-us.googleusercontent.com/_KyDDwYiRe1WHa18UweQtEZUxIyVGrC4-gyFRK73CY8Nie2RDp7pxvCo1kT7dcg6p1EZey9B40EbYN7EGJA9e0ZvIewbU1z3eiHwfZct8hy8-QVNSwZEwMjzz7PtlWXoxdwuS_NR-eQ3f06XADymmhY" alt=""><figcaption></figcaption></figure>

<figure><img src="https://lh7-us.googleusercontent.com/gU1uI_dfahx3YmM1bP4rVY4z2zXwVfiDWpgwOvt75cWzZI7RihAejoJLg_UdvXRHEWFuW_jb4pyVK3_WS4rD1JnMJA-SnaIUKB7sjlb-Loux6be1mYu_YKjAH9I_S5DQf5PdvMCufY7Bq_KzBHwgExE" alt=""><figcaption></figcaption></figure>

* Now, play the live campaign, and you will have campaign data straight into your Google Sheet.

<figure><img src="https://lh7-us.googleusercontent.com/BXw4FDzZMJOD19m1zxplYFoXfODJtrjC54PF1Ue1KFTMVu_qTM5cRGMYD5rYxgBoU4BSN4AgRjewnnOoApBNUSAOhW-syNg-d0OEMbqVpYV5h0V9oITC4GMxdOWyElqObW_Avs7tHO4SWhC0KMUVu3E" alt=""><figcaption></figcaption></figure>

***

For further assistance, please contact our support team at <support@gamifyroute.com>.
