# 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>.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.gamifyroute.com/kb/campaign-details/integrations/google-sheet.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
