1. Create new Google Sheet with one or multiple sheets. 

2. Enter wanted field names/titles on the first row and the actual data on row 2 and forward. 

3. Publish your Google Sheet to allow BannerFlow to access it. Click File > Publish to the web...

4. Make sure “Entire Document” is selected and “Automatically republish when changes are made” is ticked. Click Publish to complete.

5. Copy the URL in the browser. NOT the generated URL in the pop up.

Before the URL is ready to use, you should remove the last part of it. The image below shows you the part you need to remove in red.

6. Construct the final feed URL in the following format: http://bannerflow-feed-builder.azurewebsites.net/api/googlesheet/?url=[GOOGLE_SHEET_LINK_HERE] 

E.g.http://bannerflow-feed-builder.azurewebsites.net/api/googlesheet/?url=https://docs.google.com/spreadsheets/d/1piVpoMYLEp4cKjHljwX5b_MCVB-1H8PorAQ8Kmfevxc/pubhtml

To pull a particular sheet, simply add the parameter “sheetname”:
http://bannerflow-feed-builder.azurewebsites.net/api/googlesheet/?url=https://docs.google.com/spreadsheets/d/1piVpoMYLEp4cKjHljwX5b_MCVB-1H8PorAQ8Kmfevxc/pubhtml&sheetname=Carousel B

7. Use the constructed URL as feed source in BannerFlow - done

Did this answer your question?