---
title: Google Sheets
description: Google Sheets
---

[Skip to content](https://support.dotidot.io/en/hc/en-us/articles/360010717639-google-sheets#main-content)

[![Logo\_dark](https://support.dotidot.io/hs-fs/hubfs/Logo_dark.png?width=150&height=35&name=Logo_dark.png)](https://www.dotidot.io/)

- [Home](https://www.dotidot.io/)
- [Webinars](https://www.dotidot.io/webinars)
- [Pricing](https://www.dotidot.io/pricing)
- [Blog](https://www.dotidot.io/blog)
- [Company](https://www.dotidot.io/about)

Open main navigation

Close main navigation

- [Home](https://www.dotidot.io/)
- [Webinars](https://www.dotidot.io/webinars)
- [Pricing](https://www.dotidot.io/pricing)
- [Blog](https://www.dotidot.io/blog)
- [Company](https://www.dotidot.io/about)
- [Contact us](https://www.dotidot.io/contact)

[Contact us](https://www.dotidot.io/contact)

 How can we help you?

- There are no suggestions because the search field is empty.

1. [Dotidot knowledge base](https://support.dotidot.io/en?hsLang=en)
2. [Data Sources](https://support.dotidot.io/en/data-sources?hsLang=en)
3. [Data sources types](https://support.dotidot.io/en/data-sources?hsLang=en#data-sources-types)

# Google Sheets

There’s one thing you can’t do without when creating a product, category, or DSA campaign in Dotidot - a data feed. But what should you do if there’s no XML or CSV feed around? All you need is a Google Sheets file.

**Google sheet importer can only import sheets that have Google Spreadsheet format. Other files and spreadsheets that you upload, for example Office document spreadsheet will not work.**

If you look at the drive, other formats have a different icon, so it's easy to recognize:   
Google spreadsheet:

**![f46452cf-d6e7-46cf-818a-d4e61e7a0b3a.png](https://support.dotidot.io/hs-fs/hubfs/Knowledge%20Base%20Import/10481876858780.png?width=27&height=32&name=10481876858780.png)**

Other format: 

**![878c3b72-3732-4f2a-98e2-03a54d58e4d0.png](https://support.dotidot.io/hs-fs/hubfs/Knowledge%20Base%20Import/10481838371356.png?width=32&height=32&name=10481838371356.png)**  
**So if you don't see your sheet in your feed or enrichment, check your format. If it's not a Google spreadsheet, you can use convertor [here.](https://www.youtube.com/watch?v=77YQJ-zr9S0&ab_channel=ExcelTutorialsbyEasyClickAcademy)**

 

Open your Data Feed page and add a new source by clicking on "+".

 

![Sni\_mek\_obrazovky\_2023-05-12\_v\_16.15.35.png](https://support.dotidot.io/hubfs/Knowledge%20Base%20Import/8785828908572.png)

 Choose Google Sheets as your format. 

  

  

![Sni\_mek\_obrazovky\_2023-05-12\_v\_16.16.27.png](https://support.dotidot.io/hubfs/Knowledge%20Base%20Import/8785823845404.png)

  

  

  

 Give the data source a name ( **1.**). Next, you are going to be asked to link your Google Account ( **2.**), where the file with your feed is saved. From the app, you will be transferred to Google, where you need to allow access for Dotidot. 

  

![Sni\_mek\_obrazovky\_2023-05-12\_v\_16.17.56.png](https://support.dotidot.io/hubfs/Knowledge%20Base%20Import/8785883923484.png)

  

  

  

 Select the correct file ( **3** **.**) from the account you’ve linked up, and the specific list ( **4** **.**) the file contains. Last but not least, select the column which will be responsible for maintaining the uniqueness of each and every item, i.e. the column with unique IDs ( **5** **.**). Save the feed, and then synchronization begins. The feed will be regularly updated depending on your synchronization setup. 

 Once your account is connected, you’re the only one who can add files from your Drive—no other account within the organization can use your files and there’s no need for you to worry about someone else creating a data feed out of your files or even viewing their list. 

- [Getting started with Dotidot](https://support.dotidot.io/en/getting-started-with-dotidot?hsLang=en)
- [Data Sources](https://support.dotidot.io/en/data-sources?hsLang=en#main-content)

    - [Data sources types](https://support.dotidot.io/en/data-sources?hsLang=en#data-sources-types)
    - [Variables](https://support.dotidot.io/en/data-sources?hsLang=en#variables)
    - [Data enrichment](https://support.dotidot.io/en/data-sources?hsLang=en#data-enrichment)
    - [Feed exports](https://support.dotidot.io/en/data-sources?hsLang=en#feed-exports)
- [Campaigns](https://support.dotidot.io/en/campaigns?hsLang=en#main-content)

    - [DSA campaigns](https://support.dotidot.io/en/campaigns?hsLang=en#dsa-campaigns)
    - [Assets](https://support.dotidot.io/en/campaigns?hsLang=en#assets)
    - [Meta campaigns](https://support.dotidot.io/en/campaigns?hsLang=en#meta-campaigns)
    - [Keywords](https://support.dotidot.io/en/campaigns?hsLang=en#keywords)
- [Product Analytics](https://support.dotidot.io/en/product-analytics?hsLang=en)
- [Image Editor](https://support.dotidot.io/en/image-editor?hsLang=en)
- [Pricing and billing](https://support.dotidot.io/en/pricing-and-billing?hsLang=en)
- [Tips for using the app](https://support.dotidot.io/en/tips-for-using-the-app?hsLang=en)
- [FAQ](https://support.dotidot.io/en/faq?hsLang=en)

- [Home](https://www.dotidot.io/)
- [Webinars](https://www.dotidot.io/webinars)
- [Pricing](https://www.dotidot.io/pricing)
- [Blog](https://www.dotidot.io/blog)
- [Company](https://www.dotidot.io/about)

# Dotidot

<https://www.facebook.com/dotidot.official> <https://www.instagram.com/dotidot_official> [mailto:info@dotidot.io](mailto:info@dotidot.io)

Copyright © 2026, Dotidot