Data Sources

Google Sheets as a data source

There’s one thing you can’t do without when creating a product, category, or DSA campaign in PPC Bee—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.

 

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

 

Data_sources___PPC_Bee.png

Choose Google Sheets as your format. 
 
 
Data_sources___PPC_Bee-2.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 PPC Bee. 
 
Google_Sheets_data_source___PPC_Bee.png
 
Sni_mek_obrazovky_2020-12-01_v_13.25.40.png
 
Select the correct file (5.) from the account (4.) you’ve linked up, and the specific list (6.) 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 (7.). Save the feed, and then synchronization begins. The feed will be regularly updated depending on your subscription level. Settings.png
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. 
Blog post
Was this article helpful?
Didn’t find what you were looking for?
Ask a question