This guide explains how to use Make to automatically export supplier contacts 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.
Add a header row with the following supplier fields:
Name (required)
Email (optional)
Comment (optional)
Katana internal ID
Created at (timestamp)
Updated at (timestamp)
Step 2: Create a scenario in Make
In Make, choose Scenarios from the left side menu and click + Create scenario.
Add Katana as the first module (trigger).
Choose List Suppliers as the action.
Toggle Map Supplier IDs (to fetch all suppliers).
Adjust the Limit field if you want to pull more than the default number of records.
Save and continue.
Step 3: Add Google Sheets as the action
Add a second module: Google Sheets → Bulk Add Rows.
Select your spreadsheet and worksheet.
Map the fields from Katana to the corresponding Google Sheets columns:
Name → Name
Email → Email
Comment → Comment
Katana internal ID → Katana internal ID
Created at → Created at
Updated at → Updated at
Step 4: Run the scenario
Run the scenario once.
Supplier data from Katana will be exported into your Google Sheet.
Step 5: Avoid duplicates
If you plan to run the scenario multiple times, switch the trigger to Watch Suppliers instead of List Suppliers.
This ensures only new supplier records are added to your sheet.
Prevents duplicate entries when re-running the workflow.
That’s it! You now have an automated workflow to export suppliers from Katana into 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]