In this guide, we’ll walk you through the steps to protect your Google Sheets, ensuring your data remains private and secure.

Let’s begin by setting up access permissions for your Google Sheets. In the top-right corner click Share button.

Enter the email address provided by BannnerNow:

private-spreadsheets@bannernow-gcloud.iam.gserviceaccount.com

Click the Share button to share the spreadsheet. Viewer permission is sufficient. The platform will now have access to your Google Sheet based on the permissions you have set.

Let’s return to BannerNow and set up a new feed. Navigate to the Data menu, open the Feeds tab, and click on New feed.

Next, from the Data Source options select Google Spreadsheet.

In the modal:

1. input the name of your feed;

2. copy the link of your google spreadsheet and insert it in the Spreadsheet ID field;

3. check the Private Spreadsheet option.

And there you have it! Now your private Google Spreadsheet is serving as a dynamic feed source and you can easily manage and update the content displayed on your ads in real-time. Happy advertising!

Here’s how you can use it:

1. Open up Google Sheets

Tip: If your spreadsheet is stored as XLSX – convert it to Google Sheets first !

2. Make sure the first row contains a title for each column.

3. Next click the Share button in the top right menu.

4. Click “Change to anyone with the link“.

5. Next choose Anyone with the link option and press “Done”.

6. Next copy the document link.

7. Go back to BannerNow, Library -> Feeds -> New Feed.

8. Choose Google Spreadsheet.

9. Paste your google spreadsheet link, choose the page number and the desired update interval and click proceed.

Now you can select the data from your spreadsheet that you want to use in your banners.

Read more about creating feeded banners here.