This article walks through the process of integrating Impira with Zapier and a third app. (We’re using Google Sheets as our example, but feel free to integrate with Slack, Zoho, Salesforce, or any ERP you’re using.) This workflow will allow a user to make edits in Impira and Google Sheets and have them “speak” to each other to stay synced up by using Zapier as a means of communication.
This article accompanies the tutorial video below, but will skip the invite link step mentioned early in the video.
Zap #1: Reads data from Google Sheets, then immediately writes to (uploads files) into Impira.
Go to My Apps in the left sidebar and search for Google Sheets. Sign in.
Create a Zap that reads from Google Sheets
In Google Sheets
Prepare a new spreadsheet (e.g., “Zapier”) with two columns named “Name” and “Path.”
Copy the first two values from the example spreadsheet and paste them into your Google Sheet in row 2, under Name and Path.
NOTE: The example in the video shows the Path value as an HTTP link to a file that Impira can access.
Select Make a Zap on the left sidebar, and choose Google Sheets. We’re going to name this Zap, “Gsheets to Impira.”
For Trigger Event, choose “New Spreadsheet Row.” Continue.
Choose your Google account. Continue.
For Spreadsheet, choose “Zapier” (name of your Google Sheet)
For Worksheet, choose the name of the first sheet on Google Sheets. Our example uses “Sheet1.”
Hit Test Trigger, and you’ll see the two values from the Google Sheet show up in Zapier.
Now let’s connect to Impira. Choose Continue.
Connect to Impira
After you chose Continue from the last step, a box called “2. Action” with an orange header appeared. Search for Impira in the search bar and select it.
For Action Event, choose “Upload file.” Continue.
Sign into Impira with your organization name (found in your Impira browser URL, after `/o/`) and API key. (Your API key (or “token”) is found under User Access (gear icon) in your Impira browser window. Learn how to create your own API token here.)
Paste in your API key and select Yes, Continue. Then choose Continue.
Under Set up action, you’ll see File Name. Select “Name.”
For URL, choose, “Path.”
Now we have to create a collectionin Impira.
Go to the left sidebar and create a new collection by clicking the + icon next to COLLECTIONS. Give it a name (we’re using the name “Zapier-Test” for this demo).
Go back to Zapier and type in your new collection name under Collection Name.
Let’s give this a shot. Click Test & Continue, and you’ll see that the test was successful.
Go back to Impira to see that the file showed up in your new collection.
Double-click the file and create a few fields. We’re starting with labeling First nameand Last name. Refer to the video to see this in action (timestamp 3:27).
In Google Sheets
After training our machine learning model in Impira, we want to get the updated file information from Impira back into the Google sheet.
Go to Google Sheets and create a new sheet called “Output.”
We want to capture a few fields, so label the columns as uid, file name, First name, Last name, id, and cursor, starting from the left. Note: id and cursor are two special fields that Zapier and Impira create that help us understand the order in which events come.
Zap #2: Sees edits you’re making in Impira and writes to Google Sheets.
Go back to Zapier and choose Turn on Zap.
Choose Go to My Zaps, choose Create Zap. Name it “Impira to Gsheets.”
In the box called, “1. Trigger,” search for “Impira” under App Event.
Under Trigger Event, choose “File Record (New or Updated): Webhooks.” Continue.
For Impira Account, choose your organization. Continue.
Now we have to set up a trigger. Type in your collection name (e.g., Zapier-Test). Continue.
Hit Test Trigger, and you’ll see all your data show up. Continue.
We’ve just made it possible to work with your collection data in Impira and have those changes and updates reflected automatically in Google Sheets.
Enhancing your Zaps to work more efficiently
Now, we’re going to allow for these updates in Impira to show up in Google Sheets by automatically updating existing rows instead of stacking new row after row with each new data event. This makes for a cleaner, less cluttered Google Sheet.
Create a new action
For demonstration purposes, let’s take a few more files from our Excel sheet and paste them into Sheet1 of our Zapier Google Sheet.
After hitting Test Trigger, a box called “2. Action” should have popped up.
Create a new action by searching for “Google Sheets” (or selecting from the list below).
For Action Event, choose “Update Spreadsheet Row.” Continue.
Select your Google Sheets account, Drive, Spreadsheet, and Worksheet (“Output”).
Skip Row for now. We’ll get back to that.
Keep filling in the rest of the fields: • For UID: “uid (primary key)” • For File Name: “File name • For First Name, search for “First name label value” • For Last Name, search for “Last name label value” • For Id, “id” • For Cursor, “cursor”
Let’s get back to the Row field.
Go to Row and choose the Custom tab. Select Add a search step.
This will put a new step between our two existing steps (“1. File Record…” and “2. Update Spreadsheet Row…”).
Add Search Step
Once you confirm adding a Search Step, choose your Google Sheets account.
Choose your information again: Drive, Spreadsheet (“Zapier”), Worksheet (“Output”), Lookup Column (“uid”), Lookup Value (“uid (primary key)”).
For Bottom-Up, choose True.
Check the checkbox for “Create Google Sheets Spreadsheet Row if it doesn’t exist yet?” Continue.
Scroll down and re-enter your fields for: Uid, File Name, First Name, Last Name, Id, and Cursor. Continue.
Scroll down again and choose Test & Continue.
In Google Sheets
You can go to Google Sheets and see that our file has shown up in our Output sheet.
Choose Continue under “3. Update Spreadsheet Row in Google Sheets.”
Choose Test & Continue, then Turn on Zap.
We can start cleaning up our collection by confirming fields and fine tuning our machine learning model. This is a very simple process and Impira updates your model’s automatically in the background as you make confirmations and corrections. Refer to the video to see this in action (timestamp 8:35).
As we update our data and our models continually learn and improve themselves, Zapier sends these updates to Google Sheets. You can see that the data within the row is updating, instead of new data being added as new rows.
This is how you set up Impira and Google Sheets with Zapier so that they speak to each other, and are able to automatically stay synced.