Setting up Zapier Actions
Using DepositFix triggers in Zapier, you can easily automate actions like sending emails and notifications or updating external systems. This enables you to streamline your workflow by connecting DepositFix with other apps to enhance efficiency and communication.
Example 1: Update a Google Sheet When a New Order is Made
This example will update a Google sheet to create a new row, every time a new order is made.
For this, we will create a new google sheet called New Orders Sheet and create order ID
, amount
, created at
, status
and email address
as header columns.
![Notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F0a6f5332-a7a5-4309-8f1b-c6a03e37f836%2F45962fec-6398-45fd-9733-6a95aa781a5f%2FCleanShot_2024-06-05_at_22.04.202x.png?table=block&id=285b0403-ded9-42a7-b519-d08119499155&cache=v2)
Select the Action App and Event: From the list of Zapier apps, select "Google Sheets" as the action app where the data will be sent, and select “Update Spreadsheet Row” as the event.
![Notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F0a6f5332-a7a5-4309-8f1b-c6a03e37f836%2F8a77c3ec-10e0-4036-90d8-5ff81663b886%2FCleanShot_2024-06-05_at_22.00.412x.png?table=block&id=5ca73cf0-322c-4eba-8f08-f01d4fd15180&cache=v2)
Next, we’ll need to connect your google account where the Google sheet is located.
Map Data Fields: First, we need to select the Drive name, spreadsheet, and worksheet.
![Notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F0a6f5332-a7a5-4309-8f1b-c6a03e37f836%2F2bf9606e-ac7b-492a-ba1f-3fc04b76d167%2FCleanShot_2024-06-05_at_22.13.132x.png?table=block&id=2eee1512-3d09-42a3-8228-8f0b30473366&cache=v2)
Next, Zapier will show all fields in the Google Sheet that we can fill with data from the DepositFix trigger app. All we need to do is map the appropriate fields from trigger data to the corresponding columns in the Google Sheet.
![Notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F0a6f5332-a7a5-4309-8f1b-c6a03e37f836%2F2f5f1584-c5fe-459e-bb72-34baf78bee1f%2FCleanShot_2024-06-05_at_22.18.39.gif?table=block&id=1a3826bd-033d-4e8b-8eb1-89876e974064&cache=v2)
Test The Action: Now that we have configured the action, we need to test it to make sure that it updates the Google Sheet correctly with the trigger data. Before turning the Zap on.
To do this, click on Test Zap, and wait for Zapier to update. Now Let’s go back to the Googlesheet, and we can see that it has been updated with the correct information pulled in from the last record.
![Notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F0a6f5332-a7a5-4309-8f1b-c6a03e37f836%2F058ddc62-fc3b-4702-9de1-cfed2bc42cdc%2FCleanShot_2024-06-05_at_22.24.432x.png?table=block&id=e263bd65-0223-4df5-804b-e5081a819bd2&cache=v2)
Example 2: Send an Email Notification a Subscription Payment Fails
This example sends an email notification to the customer after their subscription payment fails. For this, we’ll select Gmail as the app, and Send Email as the action event.
![Notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F0a6f5332-a7a5-4309-8f1b-c6a03e37f836%2F04dda894-a81b-4c7c-b69a-0cd6871c91c7%2FCleanShot_2024-06-07_at_12.01.282x.png?table=block&id=2054ab4b-27c0-415f-b483-8736913779d1&cache=v2)
Next, we’ll need to connect your google account that you want to use to send emails.
![Notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F0a6f5332-a7a5-4309-8f1b-c6a03e37f836%2Fe8a661d2-cd64-46db-828e-8b5d74fe18fe%2FCleanShot_2024-06-07_at_12.03.382x.png?table=block&id=583ef28f-a662-4f6f-aa55-9e798c5b10c3&cache=v2)
Map Data Fields: Zapier will show all fields needed to send an email, that we can fill with data from the DepositFix trigger app. All we need to do is map the appropriate fields from trigger data to the corresponding columns in the Google action.
![Notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F0a6f5332-a7a5-4309-8f1b-c6a03e37f836%2Fac0040cf-c782-4c9c-9638-cc794569c98c%2FCleanShot_2024-06-07_at_12.07.462x.png?table=block&id=fdb5173f-2879-4b4c-a82a-89944033ed2b&cache=v2)
Test The Action: Now that we have configured the action, we need to test it to make sure that the email is populated with the the trigger data. Before turning the Zap on.
![Notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F0a6f5332-a7a5-4309-8f1b-c6a03e37f836%2Ff32c7898-3ea2-4bd1-a989-26dda2d66e3e%2FCleanShot_2024-06-07_at_12.11.462x.png?table=block&id=ad847109-32ef-4cc4-af0a-b7c633f1b5fc&cache=v2)
Now that we verified the data is correct, we can publish the zap!
Example 3: Update a Google Sheet When a New Subscription Payment is Made
This example will update a Google sheet to create a new row, every time a new subscription payment is made.
For this, we will create a new google sheet called Payment Plan Tracker and create Customer Email
, Product Name
, Payment Date
, Amount
, Balance Due
, and Next Payment Date
as header columns.
![Notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F0a6f5332-a7a5-4309-8f1b-c6a03e37f836%2F82acde64-4825-42d6-8741-cd84f146bdfa%2FCleanShot_2024-06-07_at_12.36.422x.png?table=block&id=2e46df8e-7e2e-4fee-9e6e-9f87fc5005b4&cache=v2)
Select the Action App and Event: From the list of Zapier apps, select "Google Sheets" as the action app where the data will be sent, and select “Update Spreadsheet Row” as the event.
![Notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F0a6f5332-a7a5-4309-8f1b-c6a03e37f836%2F8a77c3ec-10e0-4036-90d8-5ff81663b886%2FCleanShot_2024-06-05_at_22.00.412x.png?table=block&id=0bbdb41f-3de5-4f3a-896e-008308bdf063&cache=v2)
Next, we’ll need to connect your google account where the Google sheet is located.
Map Data Fields: First, we need to select the Drive name, spreadsheet, and worksheet.
![Notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F0a6f5332-a7a5-4309-8f1b-c6a03e37f836%2F47ef4d0a-65ef-4966-a87c-aedf34be3bbb%2FCleanShot_2024-06-07_at_12.31.502x.png?table=block&id=fd86e61c-530a-40f2-b990-47dd22e80ec8&cache=v2)
Next, Zapier will show all fields in the Google Sheet that we can fill with data from the DepositFix trigger app. All we need to do is map the appropriate fields from trigger data to the corresponding columns in the Google Sheet.
![Notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F0a6f5332-a7a5-4309-8f1b-c6a03e37f836%2F1f81ef4d-2218-4138-a289-9da63a2659de%2FCleanShot_2024-06-07_at_12.36.052x.png?table=block&id=43f24351-4bde-4afd-bb1a-6b3b424afdb2&cache=v2)
Test The Action: Now that we have configured the action, we need to test it to make sure that it updates the Google Sheet correctly with the trigger data. Before turning the Zap on.
To do this, click on Test Zap, and wait for Zapier to update. Now Let’s go back to the Googlesheet, and we can see that it has been updated with the correct information pulled in from the last record.
![Notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F0a6f5332-a7a5-4309-8f1b-c6a03e37f836%2F22ae240a-a4ff-47a5-b0db-b43c0752f14d%2FCleanShot_2024-06-07_at_12.37.532x.png?table=block&id=3247ab8f-2212-41b8-a3cb-c41c3e4252c5&cache=v2)