Sync with Google Sheets
Currently I have a bunch of agents who each have a google sheet. I then have these ggoel sheets compile into one sheet. This sheet is formatted for the CSV upload. I have 2 questions
1)Is there a way to auto sync Google Sheet with Eventon
2) Is there a way to auto sync that brings down the event id from assigned to events after sheet is uploaded ( incase a event is updated on the sheet, we wouldnt want to create a new event just uipdate the one uploaded previously)
-
-
May 21,2020 AT 1:47PM -
Posted 4 years ago
- #177612
Hello,
1. CSV Importer allows you to import .csv files. Unfortunately, it doesn’t allow you to import them automatically, only manually.
2. CSV Importer allows you to do this:
event_id (int) – Event post ID, if passed, event with this id will be updated with meta data
-
May 26,2020 AT 8:59AM -
Posted 4 years ago
- #178287
Doesnt answer my questrion at all
Thanks
Its there a way the CSV export doesnt have a bunch of gobble gook in the cells?
I keep getting things liker
My Main $%#^*%#* Event
-
May 26,2020 AT 12:31PM -
Posted 4 years ago
- #178326
You can export Google Sheets in different formats. For example, CSV: https://www.solveyourtech.com/save-csv-google-sheets/
After you exported it, you can import it with CSV Import (if file’s format is correct). The problem is that it doesn’t allow you to do this automatically, only manually.
Please let us know if you still have questions on this topic.
Its there a way the CSV export doesnt have a bunch of gobble gook in the cells?
Please check Google’s documentation on how to export data to files.
-
May 26,2020 AT 12:48PM -
Posted 4 years ago
- #178329
Imm talking about Eventon’s Export having a bunch of characters and gobbly gook, not Google
-
May 26,2020 AT 12:54PM -
Posted 4 years ago
- #178334
Could you send us a link to the exported file so we can check it?
-
May 21,2020 AT 1:47PM -
Posted 4 years ago
- #177612
