...
| 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.
However, there are some basic components and best practices to follow for a basic data source.
| Info |
|---|
If you need assistance formatting your Google Sheet, please reach out to your Account Manager. |
Let’s use this real estate data as an example:
...
As you can see, there are 6 inventory records listed in this sheet (rows 2-7). Each of which, has it’s own set of fields designated by the columns of the sheet (columns A-E).
Again, the number of rows and columns will always vary, as the client could also want to display things like the city, state, neighborhood, etc. in their ad, and these would require their own respective columns/fields. Additionally, they could also want to have more than six records for their data source. However, we recommend to have at least three columns/fields for every data source:
ID
Title
Image