Reflexive Forms Importer

Overview

This application is an extension for CiviCRM which is an open-source constituent management system (CRM). By installing and using this extension in CiviCRM, you will be able to import responses on your Google Forms and save them as CiviCRM entities.

Basically you can import contacts (create new contacts or update existing ones) and you can map answers for questions on a Google Form to fields on different CiviCRM entities. Additionally you can set fixed values for entity fields that are not mapped to a Forms field. This could be useful for parameters that are not coming from the responses (shouldn't be variable), rather you want the same value for all records. During import you can also mark the imported contacts with tags or put them into groups.

You can run a one-off import or you can setup a continuous import that runs as a scheduled job and checks if there are new records and imports them.

The same results can be achieved with a manual export/import process where you export the responses from Google Forms as a .csv file then with a multi-step import that file to CiviCRM. This application automatizes this process, eliminating errors and manual labor.

Example

You have a Google Form with the following fields:

• email address

• first name

• last name

• how much you like pizza (on a scale 1-5)

You can specify a mapping like this:

• Variable fields

  • email address - match to contact

  • first name - Contact::First name

  • last name - Contact::Last name

  • how much you like pizza - Contact::Pizza likeness

• Fixed fields

  • activity_type_id=3

After running the import, records will be processed. Existing contacts will be looked up by email address. If a matching email address is found, contact data will be updated (first name, last name, pizza likeness), if not a new contact will be created. Additionally an activity (type_id=3) will be added to each contact.

Copyright

This extension is developed by Reflexive Communications. All rights reserved. 2022.

Disclaimer

Reflexive Forms Importer is NOT affiliated with, endorsed or sponsored by Google in any ways.