n8n Integration

Step 1: Set Up Your n8n Project

1. Log in to your n8n account.
2. Click New Workflow to create a blank workflow.
3. Give the workflow a descriptive name.

Step 2: Define Input Variables

1. Add an Edit Fields node:
   • This node creates input variables for the API call.
2. Define input fields as text variables:
   • originZIP
   • destinationZIP
   • weight
3. Ensure inputs are stored in text format, as required by the API.

Step 3: Import API Request via cURL

1. Visit the SpreadsheetWeb API Documentation.
2. Navigate to the calculatesinglesimple endpoint:
   • Use the Try it out feature to test with sample inputs.
3. Copy the cURL request provided after execution.
   Example cURL:
    

   curl -X 'POST' \ 'https://api.spreadsheetweb.com/calculations/calculatesinglesimple' \ -H 'accept: application/json' \ -H 'Content-Type: application/json' \ -d '{ "request": { "workspaceId": "your-workspace-id", "applicationId": "your-application-id", "inputs": { "originZIP": "{{ $json.originZIP }}", "destinationZIP": "{{ $json.destinationZIP }}", "weight": "{{ $json.weight }}" }, "outputs": ["cost"] } }'

4. Add an HTTP Request node to n8n:
   • Click Import cURL and paste the cURL command.

Step 4: Configure the HTTP Request Node

1. Verify Parameters: Ensure the following details are accurate:
   • API Endpoint:

     https://api.spreadsheetweb.com/calculations/calculatesinglesimple

   • Headers:
     • Content-Type: application/json
   • Body: Map the request body to dynamic input fields:
      

     {
     "request": {
     "workspaceId": "your-workspace-id",
     "applicationId": "your-application-id",
     "inputs": {
     "originZIP": "{{ $json.originZIP }}",
     "destinationZIP": "{{ $json.destinationZIP }}",
     "weight": "{{ $json.weight }}"
     },
     "outputs": ["cost"]
     }
     }

   Replace workspaceId and applicationId with your SpreadsheetWeb credentials.

2. Map variables to the request body:
   • Drag and drop originZIP, destinationZIP, and weight from the Edit Fields node to the JSON body.

Step 5: Handle API Response

1. Add a second Edit Fields node to handle the API response.
2. Extract and store the API output:
   • Define a new field: calculatedCost.
   • Map it to the key in the API response:

     $json.response.outputs.cost

      

Step 6: Test the Workflow

1. Run the workflow with sample inputs:
   • originZIP: “10001”
   • destinationZIP: “90001”
   • weight: “1”
2. Verify the output:
   • The calculatedCost field should display the API result (e.g., “8.5785”).