> For the complete documentation index, see [llms.txt](https://docs.countercyclical.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.countercyclical.io/data-sources/google-sheets.md).

# Google Sheets

Use connected worksheets in Countercyclical and sync company fundamentals to Google Sheets.

<figure><img src="https://3856051622-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FuoSbSJEvJXClIRJg7TCt%2Fuploads%2FqwWYXwwRhGohOyeqfPra%2FGoogle%20Sheets%20Banner.png?alt=media&amp;token=bef88071-0178-465b-9309-99e29b639fb5" alt=""><figcaption><p> Google Sheets &#x26; Countercyclical</p></figcaption></figure>

Connect Google Sheets to work with spreadsheet data in Countercyclical and send selected company fundamentals to a workbook your team uses for analysis.

#### Connecting Google Sheets

1. From **Home**, choose **New Data Source**. Under **Productivity**, select **Google Sheets**.
2. Sign in to the Google account that has the workbook access you need. Review the requested permissions and finish authorization.
3. Return to Countercyclical and check the connected account in the data source manager. Select that account when picking a worksheet or a sync destination.

#### Available Data

Use the **Command Palette** to find workbooks, tabs, and records. For a report or list built from a connected worksheet, select the workbook and tab in the data source picker. Use a header row so the fields are easy to identify.

From [**Search › Companies**](https://dashboard.countercyclical.io/search/companies), select company results and open **Sync to Data Sources**. Choose Google Sheets and review the data options, including the reporting periods and normalized or as-reported financials where offered.

To bring spreadsheet financials into Countercyclical, use the financial sync flow under the import controls in Search. Choose the workbook and worksheet for each financial section and review the mapping before starting the sync.

#### Access and Connection Management

Use an account with access to the source workbook and permission to write to the destination for outbound syncs. If a tab is missing, check the account, the worksheet’s header row, and the permissions in Google Sheets.

Review or remove the connection in the data source manager.

{% hint style="warning" %}
**Before Disconnecting**

Check reports, list views, and syncs that use the account before removing it.
{% endhint %}

#### Related Pages

{% content-ref url="/pages/plAHQ1SimsH3PGqXOu5v" %}
[Syncing to Data Sources](https://docs.countercyclical.io/research/syncing-to-data-sources.md)
{% endcontent-ref %}

{% content-ref url="/pages/nVtxqRGdBRys7z2yGOlc" %}
[Vantage Queries](https://docs.countercyclical.io/relations/components/vantage-queries.md)
{% endcontent-ref %}

{% content-ref url="/pages/6f1sRBoao0VtCbDWQRjf" %}
[Command Palette](https://docs.countercyclical.io/workspaces/command-palette.md)
{% endcontent-ref %}

{% content-ref url="/pages/0xvOQOgiI0hROKrC8ZzU" %}
[Reports](https://docs.countercyclical.io/relations/reports.md)
{% endcontent-ref %}

{% content-ref url="/pages/eoX53PSLCwhVVcGw3tQc" %}
[Lists](https://docs.countercyclical.io/relations/lists.md)
{% endcontent-ref %}
