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.

1 Answer 1


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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.