Csv file to google sheets6/25/2023 If you see the option Require viewers to sign in with their account, clear it.This means that when you make changes to the spreadsheet, the changes also go to Smartly.io and your campaigns. Under Published content & settings, make sure to select Automatically republish when changes are made.(If you repeat this step later, the format might be reset to a web page, so make sure to select the CSV format every time.) Select the format Comma-separated values (.csv).If you have confidential or sensitive information in your feed, we recommend that you host the feed on your own servers and use authentication measures to restrict access to the file. ⚠️ Caution: With both options, the contents of your sheet become potentially accessible by third parties, if they get the URL to your file. Enable link sharing and get a file export link.This what the data in our example "Product Catalogue" feed would look like.Īs you will be hosting the feed on Google Drive, finish by making the feed file public to the web in CSV format. id (this is the only mandatory field and it has to be unique per row)įill in the data in the columns in your sheet.If you're creating a feed with product information, we suggest you use these data fields: Here's an example of a product feed named "Product Catalogue", with field names on the first row. To define what data fields the feed contains, enter the field names in the columns on the first row.In Google Drive, create a new Google sheet.See detailed instructions in Google's help. Read the information on feed files in general and on CSV and TSV formats, including the limitations you need to be aware of. You can try it out using this example feed. With Google Sheets, you can create a data feed in CSV format in less than 10 minutes and use it to run feed-based campaigns.Ĭreate a Google Sheet, define the data fields and their content, and publish the feed to web from Google Drive.
0 Comments
Leave a Reply. |