Import CSV into Google Sheets
Hi, this might be easy but I'm having difficulty importing a downloaded CSV file into Google sheets. The CSV is downloaded daily and then moved into Google Drive replacing the old file. Ideally I can set the file to refresh daily and append the previous data, so that there are no duplicates and we keep historical data. Is this possible in Supermetrics for Google Sheets? I imagine it is via the JSON/CSV connector, but when I try and connect to the file in Drive the format is all wrong, as I want it to look identically to the format in the CSV.