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.

Look as good as Zapier makes you feel with our new swag storefront.

2 months ago

Home
Learn and Share
Show & Tell

Show & Tell

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

288 Topics
623 Replies

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

288 Topics

Recently active

Most replies Most views Newest first

MohSwellamZapier Expert

posted in Show & Tell

Tutorial: How to Map an Empty Field in Zapier

Hey everyone, Here is a quick demo on how to map a field in Zapier dynamically even though that particular field is empty in the trigger / previous action(s) results. Hope it is helpful!

nicksimardZapier Staff

published in Show & Tell

About the Show & Tell Forum

Posts in this category should be conversational in nature, meaning that you’re not looking to get help from anyone or ask questions. It’s meant to offer a place to share tips, tricks, use cases, best practices, and workflows with your fellow Community members.You might be thinking…But, I don’t know enough to bother sharing.Not true! Everyone is capable of providing information, because nobody else has the precise experience and ideas that you do. Also, there will always be someone who is less experienced with Zapier than you and who could benefit from your knowledge Share something you could have benefited from last week.Everyone else probably already knows what I’m thinking of sharing.There is SO much to know about Zapier, combining different apps, using advanced features, coming up with clever workarounds, etc. Don’t assume that your ideas are common knowledge. You might be surprised at how many people you can help by sharing!What if what I share isn’t accurate?That’s not the end of

Pierre LandoinNew

posted in Show & Tell

How to enrich leads with emails

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

Troy TessaloneZapier Expert

posted in Show & Tell

About the Zapier Referral Program

About the Zapier Referral Program Zapier does not have a Referral Program.

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

ikbelkirasanZapier Expert

published in Show & Tell

[New Integration] Advanced Utilities

Hey everyone, I would like to share a custom Zapier integration I built to solve a few problems. The integration provides the following action steps. I hope you find it helpful. :) --- Run JavaScript Code: This is kind of a clone of the regular Code Step. Nothing fancy, it just comes with some useful tools available in the global scope. It also supports modern JavaScript async/await. The global scope includes the following utilities: moment: The well-known moment.js library that helps when dealing with date/time. _: Lodash library that makes it easier to work with objects and arrays. JSON: this replaces the built-in JSON.parse function with the more advanced JSON5 library. toCSV: A function that converts an object to CSV. --- Export to CSV: This action makes it easy to convert JSON data or line items to a CSV string or file. --- If you’re interested in trying it, here’s the invite link: https://zapier.com/developer/public-invite/112461/039174f595539444ce5c14e114c1dc1e/

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

BlakeBaileyConnector

published in Show & Tell

Starting a YouTube Channel on Automation / Tech / Productivity - Feedback Welcomed!

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 :P ).

Troy TessaloneZapier Expert

posted in Show & Tell

TIP: Insert Timestamp into Zap Step with {{zap_meta_human_now}}

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

Troy TessaloneZapier Expert

posted in Show & Tell

GUIDE: Use Calendly API to Create Single-Use Scheduling Links

GUIDE: Use Calendly API to Create Single-Use Scheduling Links RESOURCESCalendly API Personal Access Token: https://developer.calendly.com/how-to-authenticate-with-personal-access-tokensCalendly API Endpoint: https://calendly.stoplight.io/docs/api-docs/b3A6MzQyNTM0OQ-create-single-use-scheduling-linkWebhooks: https://zapier.com/apps/webhook/help CONFIGUse the Webhooks app Action Event: Custom Request Method: POST In the Data field, replace the [uuid] with your Calendly Event UUID NOTE: You can find this by testing the Calendly Zap trigger for Invitee Created In the Authorization Header, replace with your [PERSONAL ACCESS TOKEN] Tips and Inspiration contributed by: Troy Tessalone - Automation Ace

nicksimardZapier Staff

published in Show & Tell

Filters vs Paths vs Lookup Tables: A Visual Guide

Even the most seasoned Zapier user sometimes has a hard time deciding whether to use a filter with multiple Zaps, a single Zap with multiple paths, or a single Zap with a lookup table.We’re trying something a little different and providing a visual guide that hopefully helps to clarify when/why you might choose to use one over the other.Filters Paths Lookup Table Did This Help?FiltersIf you’re trying to have several different outcomes from your workflow, using multiple Zaps with a filter is one way to approach it.Click to enlarge.PathsSimilar to using multiple Zaps with a filter, Paths provide multiple outcomes using only one Zap.Click to enlarge. Lookup TablePerhaps the most misunderstood of all the options, a lookup table is beneficial when you’ve got specific fields that decide an outcome. Click to enlarge.Did This Help?Here in the Zapier community we’re always trying to create resources that are helpful to our members. We’d love to hear whether this helped to make sense of things,

Troy TessaloneZapier Expert

posted in Show & Tell

How to get a PDF version of a Google Drive file such as Google Docs, Google Sheets, or Google Slides?

How to Get the PDF Version of a GDrive File (GDocs / GSheets / GSlides) Did you know GDrive automatically makes a PDF version of the file available? Simply search for “application/pdf” in the returned response data of the Zap step! Example: GDocs Example: GSlides

DanversZapier Staff

published in Show & Tell

Delaying a Zap until a specific time of day

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

SamBCommunity Manager

published in Show & Tell

How to submit a Google Form response using a Webhook

Hey friends! Want to have a Zap submit Google Form responses? And have those responses appear in the list of form responses in Google Forms, as well as in the connected Google Sheet?Well, I have good news for you! After some digging through Google’s API docs, I figured out a way to do that using a Webhook action. You’re welcome ;-)Requirements How to get the URL for your form How to get the IDs for each form field Setting up the WebhookRequirementsIn order to set up the webhook we simply need to know two things: The URL for your Google Form The IDs for your Google Form fields Don’t know how to find that info? No worries, we’ll be covering that next...How to get the URL for your formIn Google Forms, click on the eye icon to preview your form: This will open the form in a new tab. In the address bar you’ll see the URL for your form: How to get the IDs for each form fieldA easy way to get the field ID is to use the pre-filled link option. To get the pre-filled link, when editing your G

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

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

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

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