Just wondering if it's possible to create a mail merge in InDesign using an online database, as in Google sheets. At the moment I have to export the data to my Mac, then link it to my merge page. This creates a lot of extra steps, especially if I've forgotten something. Any thoughts would be much appreciated. Thanks ahead of time.
InDesign Data Merge only works with CSV or Tab-Delimited text files. Exporting is the only way to get those if you a dealing with a program other than a plain text editor. If you were working with Excel on your computer, you would still have to export to get a usable data file.
As mentioned on the feature request page, Google Sheets actually does have a "Publish" option which publishes the sheet to an online csv. So this shouldn't be too hard for Adobe to implement! They just need to provide the option to give InDesign a a URL instead of a filepath.