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.


In the data sources tab (1.), click the New Google Sheets data source (2.) button. Then sign in to your Google account and authorize the necessary rights.
Give the data source a name (3.), 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