Important: Follow the steps with the blue bar (like this one)

Contact support if you need any assistance

Grab the    Template   

Link: sheets.co/sensorpro/6_o0u-DX

Click File then Make a Copy

Click Share then select Anyone with the link for the General Access option.

With your new Google Sheet, navigate to Extensions > App Script (will launch a script editor)

Click the blue Deploy button

Select New Deployment, Web App option

Select Execute as Me and Who as Access to Anyone

Copy the URL generated after deployment, you can test this URL in your browser:

Login to Sensorpro and Navigate to Menu->API->Configure API

Click Add New & Select Import:Salesforce for the API call type

Provide a description eg sheets1 (NB: used in next step)

Click the API configuration tab, set Auth to none and configure the API request below:

• Method: GET
• Request Header: content-type: application/json
• Request URL: Append ?offset={offset} to your sheet URL.

Then click Apply and Close.

IMPORTANT: Your API URL must include the added offset parameter.
It will look something like this:
https://script.google.com/macros/s/AKf.../exec?offset={offset}

Go to Contacts > Import then click Add New Import

Select Import using an API

Give your API a name and choose the API from the dropdown (the API description from the last step).

Click Finish

To sync on a schedule, click the Schedule tab and set a schedule. (can be done later)

After pressing Finish, the import will run.