Show & Tell

Let's say you want to send yourself a random motivational message each day, and you have a collection of inspirational quotes in a Google Sheet. We want to build a Zap that will trigger each morning and choose one of the quotes to send to you on Slack. Here's how you can do that.First, create your Google Sheet. For the first column, add the header 'Has quote' and have your quotes in the second column. In the first column, add this formula:=if(ISBLANK(B2),FALSE,TRUE)This will return the Value 'TRUE' if there's a quote in the quote column 'FALSE' if there isn't. You can copy this formula into every row - whether or not there's a quote in there now. Add your quote in the second column, and then add a third column called 'Row ID'. This third column will tell the Zap which Google Sheets Row each quote is on, which we'll need. Then create your Zap. In this case we're using Schedule as a trigger so that I can get an i

Hello!Here is a quick video showing how to use Icypeas on Zapier, to enrich leads with emails:  This video explains how to:find nominative emails from a list of prospects (including first names, last names and company names) verify existing emails find role-based emails from a list of domain namesI have also written a step-by-step tutorial available here: https://www.icypeas.com/knowledge-base-article/how-to-use-icypeas-on-zapier

Zap Apps by Zapier: No-Code vs Low-Code Zap Apps by ZapierList: https://zapier.com/apps/categories/zapier-tools No-CodeThese Zap apps are designed for users without any programming background.They allow users to create and automate workflows through a simple, user-friendly interface.The focus is on simplicity and ease of use, enabling anyone, regardless of their technical skills, to automate processes.App Status: Monitors the status of your apps within Zapier. Delay: Adds delay steps in your workflows. Email: Sends emails directly through Zapier. Filter: Filters data to decide if a Zap should continue. Formatter: Modifies data formats (also listed in Low-Code). Lead Score: Score and obtain information about your leads. Paths: Creates conditional paths in a workflow. Retrograde: Triggers when Mercury enters, is in, or leaves retrograde. Schedule: Triggers actions at scheduled times. SMS: Sends SMS messages. Space: Stay up to date on the latest space launches. Translate: Translates text

RESOURCES: How to use App APIs in Zap Steps Contribution by Troy TessaloneTroy is a Certified Zapier Expert who puts Programmable Productivity to work for YOU! EXPERTSIf you need help, there is a directory of Certified Zapier Experts: https://zapier.com/experts OVERVIEWApp APIs let you extend the capabilities of what can be done in Zap steps beyond the available Zap app triggers and actions.App APIs can have 100s of endpoints.Zap apps generally only expose the most common/popular endpoints from their API as Zap triggers/actions.Zap app triggers that use APIs are scheduled via data polling from GET requests. Zap app actions that use APIs involve these API methods. (GET, PATCH, POST, PUT, DELETE) OPTIONSZap Apps Webhooks (GET, PATCH, POST, PUT, DELETE) Triggers/Actions Help Code (JavaScript / Python) Triggers/Actions Help Zap App > Actions  Custom Actions Configure custom actions with the help of AI Handles the app authentication for you Help API Request Handle

If you’re stuck with a gmail autorisation issue, it’ because Gmail autorises data transfert to specified apps. Any built-in Zapier tool (like Weather or Code by Zapier, except for SMS/Phone by Zapier) Any Google app (like Google Sheets or Google Docs) Bombbomb (with re-authorization) Close.io (with re-authorization) (with re-authorization) Evernote (with re-authorization) Microsoft Dynamics (with re-authorization) Microsoft Excel (with re-authorization) Microsoft Office 365 (with re-authorization) Microsoft Teams (with re-authorization) Microsoft OneNote (with re-authorization) Microsoft Outlook (with re-authorization) OneDrive (with re-authorization) Pipedrive (with re-authorization) Streak (with re-authorization) Todoist (with re-authorization) The turnaround is to send your Gmail data to a Format by Zapier or Code by Zapier and let the output be the same as the input. After, send your Format by Zapier or Code by Zapier data output to any app you want. 

How to Make Zap Webhook Trigger Requests Unique with Timestamp Values to Avoid Data Deduplication Contribution by Troy TessaloneTroy is a Certified Zapier Expert who puts Programmable Productivity to work for YOU! SCENARIOIf you want to send the same data to run a Zap that uses a Webhook Catch Hook trigger, then you need to make the data request unique by adding a timestamp value.(more info below about system generated timestamps) DATA DEDUPLICATIONInfo: https://help.zapier.com/hc/en-us/articles/8496260269965-Data-deduplication-in-ZapsDeduplication is the process Zaps use to ensure your Zap only triggers for new information, avoiding duplicates.Duplicate information is managed differently in Zap triggers and actions.The deduplication system only checks within the same Zap. WEBHOOKSHelp: https://zapier.com/apps/webhook/helpWebhooks are notifications of events that happen in an app and include a payload of data about the event.HTTP REST request methods supported to fire a Zap that uses a

How to Delete a File on OpenAI using an API Request Contribution by Troy TessaloneTroy is a Certified Zapier Expert who puts Programmable Productivity to work for YOU! AppOpenAIAvailable OpenAI Zap app triggers/actions: https://zapier.com/apps/openai/integrations#triggers-and-actions ActionAction: OpenAI - API RequestNOTES:This action will handle the OpenAI authentication for you. OpenAI File IDs start with “file-” Example: file-XXXXX   APIOpenAI API docs for the endpoint: https://platform.openai.com/docs/api-reference/files/delete  CONFIGHTTP Method: DELETEURL: https://api.openai.com/v1/files/{file_id}NOTES:Map the OpenAI File ID from a previous Zap step as part of the URL You can leave all the other sections/fields blank  

Hello guys! I know all of u are experts on Zapier, so I will start to learn Zapier to offer this skill as a freelancer. Any advice ?

Zapier Template Library Linkhttps://zapier.com/templates WhatBuild and customize full-stack solutions to power mission-critical workflows.Templates allow you to instantly deploy a comprehensive no-code solution in seconds. Use CasesAI Chatbot Lead Management Onboarding Client Hub Marketing Productivity  

Hey experts! This is something I'm sure all of you can connect with. I'm looking to help as many people as possible to leverage technology, automation, and good strategy. Therefore, I've recently started a YouTube channel to summarize some of the concepts I've been teaching for years. I really look up to all of you in this group, so it's your ideas and suggestions that I value most. This is my first (actual) video, so any and all feedback or suggestions from you guys would be very much appreciated.I'll also be making content specific to different tools, comparisons, concepts, and specific integrations (as long as I can keep myself on track and focused 😛 ).

Recently I needed to compare the difference between a couple of dates and I realized that formatter doesn’t really have a good way of doing this, so I wrote a simple javascript and tried to make it as generic as possible so others in the community can use it.  My use case is that we were getting notifications of a form submission from jotform days after the form was submitted and the zap was re-processing the form submission which is what I didn’t want to have, so I wanted a simple way to “test” if {{zap_meta_human_now}} was within 30 minutes of the timestamp on the form submission, if it’s greater than 30 minutes I don’t trust it.  First a caveat, this is simple code, not perfect, and doesn’t account for the various needs, but can be adjusted to accomplish a lot of needs. Three inputs, dt1, dt2, and time_in_minutes​​​​​In the screenshot I did not use {{zap_meta_human_now}} however, in production I am using that for dt2. Javascript is pretty forgiving on the date/time format, so as lon

TIP: Insert Timestamp into Zap Step with {{zap_meta_human_now}} WhatUse a shortcut variable to insert the timestamp in a field when a Zap step runs. Articlehttps://zapier.com/help/create/customize/insert-the-time-your-zap-runs-into-a-field Timestamp formats are available:Friendly: {{zap_meta_human_now}} UNIX: {{zap_meta_timestamp}} UTC ISO-8601: {{zap_meta_utc_iso}} Other US Time Zones are available  NOTESTimestamps can help with tracing and troubleshooting Timestamps can be used as cache busters  Moderator update (May 28, 2025): For those on paid Zapier plans, it’s also possible to access the current time using a system variable. You can learn more about creating and accessing custom/system variables here: Create reusable variables to use in Zaps. If you’re not on a paid plan, it’s still possible to use the {{zap_meta_human_now}} approach as well.

Let's say that you have a Zap with any trigger, but you don't want the actions of the Zap to continue until a specific time of day. Perhaps you have an SMS service and you want to send the first message at 12pm after someone signs up, or maybe you want to gather all your new leads that come in throughout the day and send them to yourself at 7am every day. You can't do this with just one Delay step as 'Delay until' requires a specific date as well as time. So - taking the last example - you need one delay for if it's before 7am (to continue the Zap today at 7am) and one if it's after (to continue the Zap tomorrow at 7am).Thankfully you can do this pretty easily using the Formatter by Zapier app and a couple of paths. After the trigger step, add the Formatter step. Choose to work with Date/Time and then select the Format option.In the 'Input' field type: {{zap_meta_human_now}}Whenever you type that in a Zap, it creates a timestamp of whatever date and time it was when the action runs.For

Zap Custom Actions (formerly App Extensions) - RESOURCES UPDATERenamed as Custom Actions. WhatCustom Actions allow you to create custom actions for public apps on Zapier with the help of AI.Based on the app's public API, you can build missing functionality using HTTP requests. Create Edit Use Helphttps://help.zapier.com/hc/en-us/articles/16276574838925 Feedbackhttps://app-extensions.zapier.app  

The following is my problem and how I anticipate getting around it.My trigger is Airtable, and my integration is with Google Docs and Google Drive. I want to do the following:Make a folder in a shared drive Create a document in that folder based upon a template that lives in my shared drive In a zap later on, make a copy of this file and place it in that same folderI cannot do steps 2 and 3 here, as it seems like you cannot retrieve a file from a shared drive.I could change step 2 to: Create a document in that folder based upon a template that lives in my personal drive.However, step 3 does require that file being copied is in a personal drive, not a shared drive.  So here is what I’m going to do instead.Make a folder in my personal drive Shortcut that folder into the location I want in the shared driveAll steps of the zap will now act within that folder, which is in the personal drive. For context, the google account I will be using is the admin@ account for the organisation, so it sh

Hi all!I want to share my solution, maybe it will be useful to someone.This post was inspired by this question: https://community.zapier.com/how-do-i-3/adding-a-checkbox-to-a-google-sheet-2059.There are published solutions there, but maybe someone like me will not want to use "auxiliary" Tabs or do manual manipulations to manage checkboxes. Our goal:1. When a new response is received from a Google Form, insert a new row into the Google Sheet2. It should be noted that some fields in the form are checkboxes.Form field:Google FormSheet content:Google Sheet Problems we solve:1. By default, the "Create Spreadsheet Row" event will create a new row AFTER all rows that have a checkbox (even if they are not set to True)2. By default, this event will write text values to cells with checkboxes, and will not set a new checkbox (which is unexpected behavior for us)Example:New row was appended to the end of the Sheet, Checkboxes not set :( Solution:Our final Zap looks something like this in a nutshe

GDrive File Link Formats (GDocs, GSheets, GSlides) Handy ways to format GDrive file links for different use cases. Try this Tool: https://sites.google.com/site/gdocs2direct/ GDrive Files - Download and ExportThe native file viewer is useful but sometimes you may want to bypass the built-in GDrive viewer and force the browser to download the file instead of opening it. GDrive Files - Direct Download Links to Skip the Web ViewerWhen you upload any file in GDrive and share it, the shared link looks like this:https://drive.google.com/open?id=DRIVE_FILE_IDThe FILE_ID is unique for every file in GDrive.If you copy this FILE_ID and use it in the URL below, you’ll get a direct link to download the file from GDrive.https://drive.google.com/uc?export=download&id=DRIVE_FILE_IDIf you wish to open the file in the GDrive web viewer, the viewer URL would be:https://drive.google.com/file/d/DRIVE_FILE_ID/view GDocs - Direct DownloadsAny GDoc in your GDrive has a URL like:https://docs.google.com/doc

I use Google Slides and a Google Drive folder on a free Google account to create “course completion certificates” for people who complete training. My zap also emails the certificate and saves it into my database. Since I have limited storage space on the free account and it’s already stored in my database, I don’t want the old certificates just hanging out taking up space. I was looking to make a zap that would delete the certificates or move them to the trash folder. As I was trying to set this up, I learned that it’s not possible using Zapier.I looked on the forum and found a closed thread called “Deleting files in Google Drive” posted by @Martinewski that had some back and forth with @TheDavidJohnson @jesse @john_fohrman @alex but there was no real solution there. I’ve just recently started tinkering with Google Scripts and I’ve found a solution to the problem. If you create a different folder in Google Drive called something like “Temporary Trash” you can have your zap move the fi

Zapier - Social Media Accounts NOTE: Zapier does not provide support via social media channels. Twitter@Zapier @ZapierStatus FacebookPage: https://www.facebook.com/ZapierApp/ Automators Central | Zapier User Group: https://www.facebook.com/groups/228632158956270 Instagram@Zapier YouTubehttps://www.youtube.com/user/ZapierApp TikTok@Zapier LinkedInhttps://www.linkedin.com/company/zapier/ Reddithttps://www.reddit.com/r/zapier/

For Notion Users* After spending about 11 hours setting up Notion, Zapier and my Discord integration with my team, I finally think I have a solid answer! It requires a few steps, but I've manage to tag/ping my team members through Zapier, on Discord. First steps first, we'll have to start with Notion, and set up a list of team members. I used the "Multi-select" property to populate with my teams names. You'll only have to type in the first part of their Discord name here, not the #, or @. In my case I had Lentille NU for myself. After I set up my team, I went over to Zapier to set up my actions. Once the Notion database was updated, I could follow by finding my user tagged on Notion with a Discord "Find User" option. There is a delay prior to this, besides the point... Once I found my user, I managed to find their user ID. This is where I finally struck luck! Now we can use Zapier tagging options, eg <@12345690000>, or in my case <@ "User ID" > from the Find user function.

Sunset date for Universal Analytics is quickly approaching and I don’t see a native integration in GA4 as yet. Supposedly, it’s still work in progress, but this isn’t leaving much time to get things reconfigured.I created a workaround using a “Custom Request” webhook if anyone is interested. Tested and works perfectly: Method: PostURL: https://www.google-analytics.com/mp/collect?api_secret=[API-SECRET-GOES-HERE]&measurement_id=[STREAM-ID-GOES-HERE]Data:{ "client_id": "SOURCE-DATA-GOES-HERE","user_id": "SOURCE-DATA-GOES-HERE","non_personalized_ads": false,"events": [ { "name": "EVENT-NAME", "params":{ "EVENT-PARAM-1": "SOURCE-DATA-VARIABLE-GOES-HERE","EVENT-PARAM-2": "SOURCE-DATA-VARIABLE-GOES-HERE","EVENT-PARAM-3": "SOURCE-DATA-VARIABLE-GOES-HERE","EVENT-PARAM-4": "SOURCE-DATA-VARIABLE-GOES-HERE" } } ] }Unflatten: Yes Pass as many variables as you wish. See GA4 measurement protocol for documentation and references to values.

Hi All,I recently launched a new integration app on Zapier.   Vybit sends distinct, custom sound notifications that you create by choosing from thousands of possible sounds (from freesound.org). The idea is that the specific notification sound itself tells you exactly what Zap trigger fired (and if making the effort to grab and look at your device for the notification details is warranted).  Vybit is free and it also works with anything that has outbound webhooks. Please check it out including the Zap Templates, I think you will find it super useful! Questions and feedback are very welcome! Thanks, BradyVybit on Zapier

Hi everyone,We have an application that stores Trello card IDs in Airtable and I was having a hard time creating an automation in Zapier because there's no native way of getting the card by its ID (only to search by card name, which is not useful in our particular case as card names might change).Since I couldn't find a solution in other posts, I decided to share how we did it.You can get a card by its ID using an “Update Card” action (instead of “Find Card”). On the Card field pass the ID and leave all the other fields blank (so no fields are actually “updated”). This allows you to use the card from this step in further steps of the Zap.Hope it helps. 

Airtable (PAT) Personal Access Token replacing API Key in Zaps ZapsYou need to update your Zap steps that use the Airtable app.That means you will have to manually convert and configure the Zap steps using Airtable.If you need help converting your Zaps, consider hiring a Certified Zapier Expert: https://zapier.com/experts How to find out which of your Zaps are impacted.Location: Zapier > My Apps > Custom IntegrationsSelect Airtable apps. (version will be in parentheses) Choose the "Zaps" tab. Filter by 'Zap Status' = ON.   Airtable Zap AppWhen you connect to the new version of the Airtable Zap app integration, you will likely want to select the option for ALL WORKSPACES.Zapier can access the following bases and workspaces.You can only grant access to bases and workspaces you have access to.All current and future bases in all current and future workspaces AirtableAirtable API keys will be deprecated by the end of January 2024 After this date, API keys will stop working and you wil