This guide explains how to use Make to automatically export stock transfers from Katana into Google Sheets.
For background, see our Make integration overview.
Step 1: Prepare your Google Sheet
Open Google Sheets and create a new spreadsheet.
For easier organization, we recommend using two sheets:
Sheet 1: Locations
Sheet 2: Stock Transfers
Add header rows. Possible fields for stock transfers include:
Stock transfer number
Stock transfer row(s)
Source location
Target location
Transfer date
Additional info
Katana internal ID
Created at (timestamp)
Updated at (timestamp)
Step 2: Create a scenario in Make
In Make, click + Create a new scenario.
Add Katana as the first module (trigger).
Choose List Stock Transfers.
This will pull all stock transfer records from Katana.
Fill in the configuration fields.
You can map row IDs with variant IDs to fetch product/material names for each transfer row.
Click Save and continue.
Step 3: Add Google Sheets as the action
Add a new module: Google Sheets → Bulk Add Rows.
Select your spreadsheet and the appropriate sheet (e.g., Stock Transfers).
Map fields from Katana to the matching Google Sheets columns, for example:
Stock transfer number → Stock transfer number
Source location → Source location
Target location → Target location
Transfer date → Transfer date
Additional info → Additional info
Variant/product details (via variant ID mapping) → Stock transfer row(s)
Step 4: Run the scenario
You now have an automated workflow to export stock transfers from Katana to Google Sheets with Make.
Your feedback is invaluable. Let us know your thoughts on this article or anything in Katana you'd like to see improved: [email protected]