make data merge possible from Google Sheet without being forced to make csv
I use DataMerge a lot and its really boring to be forced to export an update to csv when working in collaboration.
If we could use directly the source file Google Sheet we could improve our workflow (Easy Catalog does it !)
Yes, @indesign team, please make this happen!
Max Seidman commented
This would be an amazing feature. I do a lot of collaborative work on tabletop games in Google sheets and being able to take out the extra step of downloading and browsing for a new CSV from a Google sheet would save a lot of time.
Additionally, Google Sheets has the ability to publish a CSV to the web from your Google sheet, so Adobe wouldn't even need to use Google's API—all that we need is the ability to give InDesign a URL for the CSV instead of a local file path.
And if possible Microsoft Excel (Xlsx) (Xls)