About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

[Resolved] - Zap editor not accessible

12 hours ago

Home
Learn and Share
Show & Tell

Show & Tell

Show off your Zaps, workarounds, and tricks. Tell others what you’re building with Zapier.

287 Topics
623 Replies

When you subscribe we will email you when there is a new topic in this category

287 Topics

Newest first

Recently active Most replies Most views

wNuttBeginner

posted in Show & Tell

Manage Gmail filters with Google Sheets + Zapier

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.For months we've refined a system that makes it easier to manage Gmail filters. It eliminates friction and saves time for us every day.Give it a whirl and let me know what you think.

Troy TessaloneZapier Expert

posted in Show & Tell

Zap Apps by Zapier: No-Code vs Low-Code

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

Troy TessaloneZapier Expert

posted in Show & Tell

RESOURCES: How to use App APIs in Zap Steps

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! 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 Code (JavaScript / Python) Triggers/Actions Help Webhooks (GET, PATCH, POST, PUT, DELETE) Triggers/Actions Help Zap App > Actions API Request Handles the app authentication for you Help App Extensions Configure custom actions with the help of AI Handles the app authentication for you Help App Actions Some Zap apps have an action for using the a

posted in Show & Tell

RESOLVED Gmail data can only be sent to approved apps. Unfortunately, the app you are using is no longer supported. You'll need to edit your Zap to turn it back on.

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.

Troy TessaloneZapier Expert

posted in Show & Tell

How to Make Zap Webhook Trigger Requests Unique with Timestamp Values to Avoid Data Deduplication

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

Troy TessaloneZapier Expert

posted in Show & Tell

How to Delete a File on OpenAI using an API Request

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

asked in Show & Tell

Learning Zapier to offer as a freelance skill: any advice?

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 ?

Troy TessaloneZapier Expert

posted in Show & Tell

Zapier Template Library - Full-Stack No-Code Solutions

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

NyarlathotepBeginner

posted in Show & Tell

Shared Drives - Templates, Copies, and Folder Creation

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

posted in Show & Tell

Insert a new row when submitting a Google Form to Google Sheets with a Checkbox

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

Troy TessaloneZapier Expert

posted in Show & Tell

GDrive File Link Formats (GSheets, GDocs, GSlides)

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

Troy TessaloneZapier Expert

posted in Show & Tell

Zapier - Social Media Accounts

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/

kmcquaitBeginner

posted in Show & Tell

Deleting files in Google Drive solution

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

asked in Show & Tell

Tagging Notion, or other Platform users in Discord

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.

Troy TessaloneZapier Expert

asked in Show & Tell

Zap App Extensions - RESOURCES

Zap App Extensions - RESOURCES WhatApp Extensions allow you to create custom actions for public apps on Zapier.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 AbbreviationZap App Ext

sistemasUpBeginner

posted in Show & Tell

Workaround to Retrieve Trello Cards by ID Using the Update Card action

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.

Troy TessaloneZapier Expert

asked in Show & Tell

Airtable (PAT) Personal Access Token replacing API Key in Zaps

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

Woozie83Tinkerer

asked in Show & Tell

NLA uses and issues

im trying to dive into Zapier Natural Language Actions today… this seems like a cool way to integrate AI into your Zap workflows…. if you have no clue what im talking about start here: https://nla.zapier.com/get-started/got my dev API key… literally as I was typing this out I figured out my issue so I’ll leave it here just in case this helps anyone:///I first set up everything in the demo mode then made my Dev API key and it wasn’t working… make sure you set up your actions on the DEV side so your API key will work… in image below make sure to click on manage actions under the Dev App row// Once you add in actions can you can call on these actions in your workflow… For example first flow I made was link up find gmail and create a draft… I then ran the prompt (Find the last email from JC (my boss)) and draft a reply” … having some glitches with what info the AI is actually putting in the body of the draft emails and wanted to see if anyone has had good success with thisI’m also lookin

KirkZapier Staff

posted in Show & Tell

Split Text into Chunks for AI Prompt (beta) Formatter transform released

Hey All.A problem that many have been running into as AI becomes part of more workflows is the token limits of the different LLM models. To help work around this, we’ve released a new beta Text transform for Formatter - Split Text into Chunks for AI Prompt (beta). Chunks being the AI parlance for a segment of text that fits under your LLM model’s token limits.We have some initial help for this here, and have included a Zap Template that can help get you started. It’s a rather complex workflow that we’d like to make simpler over time.If you build out a Zap using this transform, we’d love feedback on how it goes.Kirk

J LivelyBeginner

posted in Show & Tell

Zapier integration with Google Analytics 4 (GA4)

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.

DanversZapier Staff

published in Show & Tell

How Zapier teammates combine Zapier and AI to simplify tasks

A core value of Zapier is ‘Build the Robot’. No matter your role, you’ll find yourself doing repetitive work. Zapier is all about finding ways to work better—whether through automation, simplification, or prioritization—so that we can spend more time doing what humans do best. With the new developments in AI, especially AI models like ChatGPT, there’s even more ways to automate and simplify tasks. This article focuses on simple use cases that individuals at Zapier use to reduce day-to-day admin and keep their days running smoothly. You’ll find links to the Zaps that we talk about so you can try them for yourself! Aubry Stewart - Sr Technical Support Specialist at Zapier I've been using a Zap that creates an item in Todoist whenever I save a message in Slack. The problem was, the titles for the items weren’t great, there’s no subject/title field in a Slack message, so I just used the author. That was pretty messy and not ideal. I've added an extra step with ChatGPT, asking it to creat

chanelleZapier Staff

published in Show & Tell

Leveraging AI for marketing: How ChatGPT can generate contentTutorial

TL;DR: In this article, we explore how AI, specifically ChatGPT from OpenAI, can be used for Ads and Marketing purposes. It can help generate content for social media engagement, blog and website content, book descriptions and blurbs, and email campaigns. However, reviewing and editing the generated content is critical to align with brand and messaging. This article is for you if: You are looking to use AI to help you create content You are trying to establish the use of AI in your everyday workflowIn my last post, we discussed using AI to help write content using the appropriate voice and tone. Today, we’ll dive a little deeper into the topic, and hone in on using it for Ads and Marketing. We’ll continue with the persona of a content creator, in this case an author marketing a book. If you haven't already, I’d recommend taking a quick peek at the tone and voice article. It will serve as a great introduction to prompting ChatGPT. While the scenario we are using for this case study is a

chanelleZapier Staff

published in Show & Tell

Transfer Wix Subscribers to Your Newsletter AppTutorial

This article is for you if; You’re a business owner A freelancer An author, writer, or blogger You work with non-profits or campaigns In today's digital age, email marketing remains one of the most effective ways businesses connect with customers. However, keeping your email list up to date and ensuring that you are adding new subscribers regularly can be a time-consuming and challenging task. That's where Zapier comes in. By setting up a new subscriber Zap for newsletter apps like Mailerlite, you can automate the process of adding or updating subscribers, saving you time and effort while ensuring that your email list is always up to date. This article will explore the benefits of setting up a new subscriber Zap and how it can help you manage your email list more efficiently.✋Disclaimer ✋If using the Wix integration, there is a bit of setup work required. You must set up your initial automation sequence on the Wix website. See below for an example of what this could look like: Let’s

Troy TessaloneZapier Expert

posted in Show & Tell

[GUIDE] How to use ChatGPT as an Email Parser

[GUIDE] How to use ChatGPT for Email Parsing Contribution by Troy TessaloneCertified Zapier Expert at Automation Ace. PurposeEmail parsing using an email parser is an alternative to automating workflows when app APIs and webhook events are not an available option for sending data.Now with AI (artificial intelligence), ChatGPT can be used as an email parser to do email parsing.This guide will show you how! NOTE: You will need a paid OpenAI / ChatGPT account in order to use the app in a Zap.(ChatGPT requests cost fractions of a penny to run.) Email Parsing(Definition provided by ChatGPT)Email parsing refers to the process of analyzing an email message's contents and structure to extract specific pieces of information or data automatically. This involves breaking down the message into its component parts, such as the sender's name and email address, the recipient's name and email address, the subject line, and the body of the message, and then organizing and categorizing this information

chanelleZapier Staff

published in Show & Tell

Small Business Series: Translate by ZapierBlog

This article is for you if: You’re a small business owner looking to broaden your business capabilities A small business owner looking to better connect with international clientele Running a small business and want to connect with a broader audience? Welcome to our new Community series, where we look at how Zapier can help you become the organized, efficient, successful small business owner you were destined to be! Our world is full of many beautiful languages and attached to those languages are customers who want to work with you or buy your products. Don’t let the language barrier stop you from achieving international success. Let’s take a look at three beneficial Zaps to set yourself up for success. Auto-Respond to non-native language emails in their language:P.S. You can do this with Office 365 services tooP.S.S. Hesitant to press send? Check out this Draft option where you can double check your email is good to go, before manually pressing send. Translate Comments Newly Submitted

1
2
3
4
...
12

Page 1 / 12

Powered by Gainsight

Terms & Conditions

Sign up

Already have an account? Login

Use your Zapier credentials

Log in with Zapier

Log in to the Community

Use your Zapier credentials

Log in with Zapier

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK

Pricing
Help
Developer Platform
Press
Jobs
Zapier for Companies
Templates

Follow us

Zapier

© 2023 Zapier Inc.

Legal
Privacy