π§ Step 1: Prepare Your Google Sheet
Create a sheet with the following columns:
Column Name | Description |
| ID of the warehouse to apply the adjustment |
| ID of the product to adjust |
| Type of adjustment ( |
| Quantity to be adjusted |
| Reason for the adjustment |
Ensure the header row is in the first row of the sheet.
π Step 2: Set Up Google Sheets Trigger in Make
Create a new scenario in Make.
Add a new module β Choose Google Sheets > Watch New Rows.
Configure the module:
Connection: Connect your Google account.
Search Method: Select Search by path.
Drive: Choose My Drive.
Spreadsheet ID: Select your prepared file.
Sheet Name: Select the relevant sheet.
Table contains headers: Yes.
Row with headers: A1:E1
Limit: Set the number of rows Make should watch (e.g., 10).
Under Choose where to start, select All to process all rows.
π Step 3: Add HTTP Request to Call Sumtracker API
Add another module β Choose HTTP > Make a Request.
Configure the module as follows:
Method:
POST
URL:
https://inventory-api.sumtracker.com/api/version/2025-03/stock/adjustment/
Headers:
Name | Value |
Authorization |
|
content-type |
|
accept |
|
Body Type: Raw
Content Type: JSON (application/json)
Request Body (use Make variables from Google Sheets):
{
"adjustment_type": "<select (type) header>",
"product_id": <select (product_id) header>,
"quantity": <select (quantity) header>,
"warehouse_id": <select (warehouse_id) header>,
"reason": "<select (reason) header>"
}
After selecting the correct headers, request content should look like this:
βΆοΈ Step 4: Run & Test the Scenario
Save the scenario.
Run once to test.
You should see the stock adjustment reflected in Sumtracker immediately.
If successful, set the scenario to run automatically on schedule.