How do I create my Google GSheet connector?

There are several steps to follow: 

  1. Publish the data source
  2. Create the connector
  3. Configuring the fields

 

1. Publish the data source

First of all, the data from your source, in this case the GSheet document, must be published.

Otherwise, they are not accessible and therefore impossible to exploit them in a third party tool.

 

How do I publish a Google Sheet document?  

File > Publish to the Web

click on Publish

mceclip1.png

 

From there you can retrieve the url of your document directly in the browser 

mceclip4.png

 

Then, you can retrieve the id of your document which will be asked when creating the connector, it is highlighted in blue in the image above.

 

2. Create the connector

From the connector tool, click on Add Connector 

mceclip5.png

In the list of templates, choose the Google SpreadSheet connector

mceclip6.png

 

2. Set up the fields

mceclip7.png

All that remains is to configure the fields retrieved from the source.

Fields  => this corresponds to the column headers in your file. These cells are therefore not editable.

 

Name => Here you can rename these parameters as you wish. This is what will be displayed in your report.

 

Type => Is it a metric, a dimension, a date? 

mceclip8.png

 

Aggregation => Here you configure the format and aggregation. It all depends on the data.

 

 

 

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.