This is the Google sheet I used to update contacts with which you can make a copy to use.

Regarding the spreadsheet, you do not have to have the ID (column A). But if you want to update by ID, you have to export your data (settings -> export). Also, if you do update by ID, you will have to change the settings below.

Use the images below to guide you in building your first Zap. If these images are hard to see, please try zooming in on the page.

Log into Zapier and make a Zap

Search for Google sheets

Connect a Google sheets account

Fill in the fields, make sure to select your column called "Update" in the third step

For the second action, search for webhook

Select custom request

Make your template look like this:

You can copy/paste the text below in.

https://api.prosperworks.com/developer_api/v1/people/fetch_by_email

X-PW-UserEmail

X-PW-AccessToken

X-PW-Application

Content-Type

developer_api

application/json

When all the fields have been filled out like the image above, hit to test this step and then select "Create & Continue"

If it was not successful (a red error message pops up), check to make sure all fields are filled out correctly, and try deleting and readding the email

If you are successful, you should click "view your custom request" to see what it is you got back.