Is there an easy (semi-)automatic way to get data from CiviCRM to Google Spreadsheets?
Data on CiviCRM side could come from search results (smart group) or a report.
On Google Spreadsheets side I would like to import data in specific document and replace particular sheet. Other sheets would then contain formulas to retrieve and process data from the imported sheet.
I would like the whole process to run it with a single click or even time-based (cron) to save time and eliminate human error in the process of exporting and re-importing regularly.
Has anyone seen or made anything similar?