See also

Tags

spreadsheet solution
17 Oct 2024 02:12 AM

Connecting a Google Sheet

close

Copy URL of a spreadsheet

To connect a spreadsheet, first copy its URL. If the spreadsheet contains multiple sheets(tabs), make sure to copy the URL of the specific tab you want.

You can then use this URL with Copilot or Workflow.

If you need to connect multiple sheets, each sheet must be connected individually.

Open the Connection UI

In Copilot:
clipboard-2024-10-16-00-46-21-701Z.png
In Workflows:
clipboard-2024-07-30-17-49-35-041Z.png

Configuration Overview

clipboard-2024-06-07-15-35-12-271Z.png

Specifying the URL

  1. You can specify the URL of the entire spreadsheet or a specific tab. It's best to use Copy & Paste.
  2. To change the URL, click on the button with the Pencil icon, then enter the new URL.
  3. If you make changes to the columns in your spreadsheet, refresh the list of columns and their types.
  4. You can open the spreadsheet in a separate window for easier access.

Configuring International Formats

  1. Configure international formats for numbers
  2. and dates in the downloadable spreadsheet.

Finding the Table

  1. If the column names in your spreadsheet start on a different row,

5b1d3abc-5220-475a-bc0a-23e1125eff50.png

this means you need to adjust the "Read from line" setting (1) in Conduit.
e4ee98cb-4bcd-4b66-b34f-87dcd297beac.png

Configuring Columns for Analysis

  1. Select only the columns needed for analysis.
  2. Specify the column kind(dimensions or metrics).
  3. For metrics, ensure the correct type is specified
  4. and choose an appropriate aggregating function.