...
Publish to web (recommended)
Edit URL manually
Publish to Web
To make a spreadsheet available for a large audience to see, publish the file. For the purposes of HootVid, we will need access to the sheet in order to configure the URL. After you publish your file you can add your new URL as a data source in the HootVid platform.
...
Copy the URL and add as a data source in HootVid.
Edit URL Manually
Doing so is fairly straightforward, you need to remove the section of the URL starting from /edit and replace it with /export with some additional text.
...
| Info |
|---|
Notice that the difference is we included &gid=1330027783 to the URL. This is basically the "Sheet ID" and as you switch sheets/tabs in Google Sheets, you'll notice this value changes and you can basically just copy that ID and append it to the URL if you want that specific sheet exported. |
...
Google Sheet Formatting
The formatting of your Google Sheet will entirely depend on the dynamic inventory that you’d like to display in your data source. For example, different verticals will necessitate different fields, or you may want to display more/less fields depending on your dynamic inventory.
...