CiviCRM Stack Exchange is a question and answer site for administrators and users of the CiviCRM Constituent Relationship Management software. It only takes a minute to sign up.
Sign up to join this community
Has anyone heard of some CiviCRM contact or data import tools made with Google Spreadsheets / Google Apps Scripts that can be customized for specific use?
I do a lot of various semi-automatic data processing in spreadsheets and creating proper CSVs every time is a challenge.
Here's an example. We have a WP-hosted Civi install using the v3 API. This pulls contact records from some smart groups and dumps the entries as a table in a google sheet. Other pages on that sheet automatically parse/filter the data table. I'm a novice coder, so perhaps clunky, but it will give you the guts of the API calls and sheet filling.
