Note: Make sure the Google Spreadsheet is already created
in your google drive with the required names of the spreadsheet and worksheet.
All the column names should be specified which you want to sync from MOHID to
the Google Sheet. Refer to the end of the article for the list of columns
available in each trigger for syncing.
Step 1: Create New Donor zap:
· Login
to Zapier Account
· From
the left sidebar, navigate to the "Zaps" section.
· Click Create button> New Zap option
- Select MOHID App as the Trigger App.
- Authenticate using your Masjid Key (it can be obtained from MOHID Admin Dashboard> General Information screen).

· For Trigger Event, select New Donor.
· Click
on Continue. Then Click Test Trigger.
Complete all the steps and
test the trigger to ensure the MOHID app is connected successfully to your
Zapier account.

· Click
on Action
- Under the "Action" step, search and
select Google Sheets.

- Choose the Action Event: Create
Spreadsheet Row.

- Connect your Google account.
- Click Continue

- Select the Drive and Spreadsheet
details to which you want to sync the data from MOHID.

· Now
complete the mapping of the column in your Google Sheet to the MOHID data. This will ensure that the data from MOHID is
entered in correct column of Google Sheets.
· After
completing mapping of all fields, click on Continue button.

· Make
sure to test the step to ensure that data is entered correctly in the google
sheet and all fields' mapping is completed accurately.

- Click on Publish button if all the required setup is completed. This
will allow your Zap to run automatically every 2 mins and sync data from MOHID
to your Google Sheets.


Step 2: Create Update Donor zap:
This zap will ensure
that if any donor data is updated in MOHID then it is synced with your google
sheet and update the required donor’s data.
- Click Create button> New Zap option
- Select MOHID App as the Trigger App.
- Authenticate using your Masjid Key (it can be obtained from MOHID Admin Dashboard> General Information screen).

· For Trigger Event, select “Update Donor”.
- Click on Continue. Then click Test
Trigger.

· Click
on Action

- Under the "Action" step, search and
select Google Sheets.

- Choose the Lookup Spreadsheet Row as Action Event.

- Connect your Google account.
- Click Continue

- Select the Drive and Spreadsheet details to
which you want to sync the data from MOHID.

- For Lookup Column, select the column that holds ID (it is a unique identifier for your data)
- For Lookup Value, map the ID field from the MOHID Zapier App.

- Enable the option: Create Google
Sheets Row if it doesn’t exist yet
- Now
complete the mapping of the column in your Google Sheet to the MOHID data.
- Click on Continue

· Complete all the steps and
test the trigger to ensure the MOHID app is connected successfully to your
Zapier account.
· Click on Publish button if all the required setup is completed. This
will allow your Zap to run automatically every 2 mins and sync data from MOHID
to your Google Sheets

· Click
on + sign to add an action. Now we
will define a trigger to update the record in google sheet.

· Click
on Action
- Under the "Action" step, search and
select Google Sheets.

· Choose
the Action Event: Update
Spreadsheet Row.
· Click
on Continue button
· Select
the Drive and Spreadsheet details to which you want to sync the data from
MOHID.
· Click
on 3 dots for Row
· Click
on Custom
· Click
on Lookup Spreadsheet Row in Google Sheet
· Select Row


· Complete
the mapping of the remaining fields to get data from Mohid App.

· Complete all the steps and
test the trigger to ensure the MOHID app is connected successfully to your
Zapier account.
· Click
on Publish button if all the required setup is completed. This will allow your
Zap to run automatically every 2 mins and sync data from MOHID to your Google
Sheets.

