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 "+".



Choose Google Sheets as your format. 
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. 
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.
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