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 Apps 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.

Get Help

Find answers to your questions. Ask the Community for help or hire someone to help you.

17417 Topics

J
JuliePoss
asked in How Do I

Zap: Google Sheets to Airtable - creates new record in Airtable instead of updating eventhough a "Find record" step is included

Hello Zap Community!I'm trying to set up a Zap with Google Sheets and Airtable wanting it to "Update record in Airtable when new or updated row in Google Sheet". I successfully set up another Zap where it creates a new record when a new row is created in the chosen Google worksheet. However, I also want a Zap that just simply updates the existing matching records in Airtable when rows in Google Sheets are edited.  I played around, and made a Zap that was kind of "working" - however, when I update rows in Sheets it just created new records in Airtable. I have set up three steps:Google Sheet as the trigger: new or updated row Action: Find record in Airtable (making it look for a matching record in Airtable) Action: Update record in Airtable if it matches the record that was found What I have done so far is to set up a Google Sheet worksheet as a trigger - here there is no problem. Then I've added a "Find Record in Airtable" step in the Zap, as I want the Zap to look through existing Airt

4
steph.n
2 years ago
I
ITB-CGCBeginner
asked in How Do I

Create office 365 calendar event

I use Service Titan and office 365.  I am trying to figure out if I can send a calendar invite in Office 365 to the assigned tech whenever a sales job is scheduled in ST.i have been un able to accomplish this yet, so any help or insight would be greatly appreciated.

7
steph.n
2 years ago
L
LorenzoBeginner
asked in How Do I

Gsuite

Hallo, i’m trying to make zaps that work with gsuite, particularly i would like to have a sheet that add user automatically. Does someone have experience in that field?

11
G
2 years ago
L
LoadxNew
asked in How Do I

Quickbooks bill and invoice line item help

I'm creating a zap from my Knack database. My Knack database has a form to enter new dispatched loads for my driver's. Each record has driver pay info. My drivers are Vendors in QuickBooks Online and get paid at the end of the week for all loads done that week.So I wanted to create a zap that looks for all records that were added in the week for each driver, and then create a single Bill for each driver (Vendor). Each drivers bill would have multiple line items (each line item is a load pay record from Knack.)So the in QuickBooks I would have 1 bill for Driver A. Line item 1: Load #1234, $100. Line item 2: Load #6789, $500, etc etc. And the final bill total would be the total amount I need to pay him for the loads he did that week.I'm stuck on making that zap happen. How do I get multiple database records that don't have any connection to each other combine onto a single Bill as multiple line items? Help!! Thanks

3
steph.n
2 years ago
T
turisBeginner
asked in Code & Webhooks

Custom webhook: Content-Length and Host headers

Hi,Looks like Custom request webhook does not automatically include “Content-Length” and/or “Host” headers. However, when I use GET/POST or PUT request (not custom request), looks like the headers are included, but I cannot use them as I need custom request body because I am working with GraphQL API. How do I add “Content-Length” and/or “Host” headers to “Custom request” Webhook? Thanks!Richard

5
T
2 years ago
O
olderbrotherBeginner
asked in How Do I

Global keyboard shortcut as trigger?

I’d like to trigger a zap just by typing a keyboard shortcut (on my Mac) from within any app. Lots of apps have these (e.g. LaunchBar, OmniFocus), but I can’t find one that will let me enter text to send to a zap.Zapier has some nice triggers of its own. Can it make one for a global shortcut trigger?Any Mac users have other ideas? Thanks in advance.

4
O
2 years ago
S
scauffielBeginner
asked in How Do I

File copy from OneDrive to Dropbox

Hey guys, I’ve got an app that takes a picture and uploads it to a directory in OneDrive.  I want to create a Zap that, when it sees a new file hit that directory, simply copies that new image to a directory in Dropbox.  Done.  That’s it.  Each image is named according to the datetime so there won’t be any duplicates.  Regardless I can’t get this to work.  Anyone ever done something like this and got it to work?  

5
S
2 years ago
V
vishal_userBeginner
asked in How Do I

Find more then 10 rows data from google sheet . Zapier integration

I am having a zap which requires to find rows from google sheet and perform operation.But the zapier action can only find max 10 rows from sheet.Can anyone provide solution regarding this?thanks

4
AndrewJDavison_Luhhu
2 years ago
D
danielafinkelNew
asked in How Do I

Automatically tag subscribers on Mailchimp

Hi!I would like to know if there is a way in which i can automatically tag already existing mailchimp subscribers that come from a specific sign up form on a landing page. I am hosting a webinar and i am sending my current mialchimp list an email inviting them to register. However, I only want to continue sending e-mails regarding this webinar only to the ones that register. I know Tags are useful for this matter but I am not able to find a way to automatically tag existing subscribers.  I hope someone can help me! Thank you!

3
AndrewJDavison_Luhhu
2 years ago
automated birthday emails
automated birthday emailsBeginner
asked in How Do I

Test trigger step

I tested the trigger and it worked then but on the actual day of the event it didn't trigger the email. What event should I select here to keep trigger the emails automatically when it finds matching word in the calendar title 

4
AndrewJDavison_Luhhu
2 years ago
K
kamiwNew
asked in How Do I

The app returned "The request was malformed".

Hi everyone, I new in this so my question might be silly/ i`m trying to connect my zappier to my wix but after do all steps on the end is a test wich gives me back : The app returned "The request was malformed".I know that in Recipient E-Mail Address shoukd be customer address but after I click to open drop box there is no any option for choose email…..Am I doing something wrong in WIx ? 

2
AndrewJDavison_Luhhu
2 years ago
C
CoachAnneNew
asked in How Do I

Error when sending and email with GMAIL

I’m encountering an issue with sending out an email with GMAIL. I receive the following error. Gmail: The app returned "Sorry... body { font-family: verdana, arial, sans-serif; background-color: #fff; color: #000; }GoogleSorry...We're sorry...... but your computer or network may be sending automated queries. To protect...". The workflow of the zap is: an appointment is created in Acuity, this triggers the zap to look for a record with matching information in Airtable, an email via a dedicated gmail account  is sent out with information pulled in from that Airtable record. The dedicated gmail account is only used for these emails. The emails are plain body. There is a signature pulled in from the gmail account and an attached pdf document.  The number of emails generated through this zap is less than 1000 per month. It doesn’t occur every time; rather it occurs randomly. 

3
AndrewJDavison_Luhhu
2 years ago
A
aaronraikesNew
asked in How Do I

Jira Service Cloud - Formatting

I can’t figure out how to format from Zapier to Jira Service Desk. I need Bold/Italic etc and none of the formats I use work. When typing in the description box I have tried *BOLD* and <b>BOLD</b> and neither work. 

2
AndrewJDavison_Luhhu
2 years ago
J
Jane poolBeginner
asked in How Do I

Create an Excel Report or PDF that has data from SalesForce.

I am trying to figure out how to pull selected opportunity records from SalesForce to create a report that I can send via email.  Only our licensed SalesForce users can create and subscribe to SalesForce reports. I thought I could use Zapier so that I don’t have to create the report manually.  Does anyone know how I can accomplish this?  I’d like to select Opportunity records that have specified field values.

2
AndrewJDavison_Luhhu
2 years ago
S
Stevieba
posted in Code & Webhooks

Zapier JavaScript destroying PhantomBuster data

This post is related to a previous post by Trevor here: I’m a software dev and I work with Trevor, I was having a look at the workflow to try and solve the issue. The “inserting a fake entry hack” before the input data for every field fixed the issue with the indexes getting mixed up.But the next issue became that The Zapier JavaScript tool doesn’t let you take the input object as the output object from the previous step. So you have to choose fields you want to add to you input object.It seems the issue is that Zapier splits the data by comma. Some of the data is people names from linkedin provided by the PhantomBuster app where they put their qualifications in the name.Example - The second object of phantomOutput is real data with the first and last name switched out….const phantomOutput = { 1: { name: 'Phil Murray', firstName: 'Phil', lastName: 'Murray', }, 2: { name: 'Nick Cage, PE, GE, DGE', firstName: 'Nick', lastName: 'Cage, PE,

2
S
2 years ago
E
Eric.font
posted in How Do I

How to pass notes from evernote to todoist

Hi guys, I would love to know how to integrate evernote into my todoist. I’ve seen videos on Youtube where a logo from evernote comes up in todoist once the task is created.  Let me know if you know how to do it! Best, Eric

2
nicksimard
Community Manager
2 years ago
A
Anonymous
asked in How Do I

Update custom field on QuickBooks invoices

I have a custom field I have created in each Quickbooks Online Invoice to record our actual shipping costs. I am extracting these costs from CSV files, but cannot figure out how to write this one value into this one field in an invoice.I have the values ready in formatter, and have got the correct invoice in the QBO Action. All I need is a way to “post” this value in the custom field.Has anyone done this?Thanks!

3
steph.n
2 years ago
K
kurashuBeginner
asked in How Do I

Google Tasks error connecting to Zapier

Hi all, I’ve been unsuccessfully trying to connect Zapier to Google Tasks (to send tasks to Todoist).I choose the proper Google account which I use for tasks and get the following message: Zapier could not connect to your account.The app returned "Invalid grant_type:". No connection to the app is formed.Has anyone had this issue and successfully solved it?Note: I use the same google account to connect to Zapier. Not sure if that may be causing issues.Thank you!

34
Danvers
Community Manager
2 years ago
E
EUReporterBeginner
asked in How Do I

Authentication failing with Wordpress since Server Move

Hi, I’m hoping someone can help save my website’s automation, as there is no service available like Zapier and I rely on it heavily for the functionality of my site. For 3 months now (since a recent server migration) I have been unable to keep the authentication between Wordpress and Zapier. It works temporarily, but then always tells me it’s become disconnected minutes later.I have tried creating a separate Zapier account, and this does nothing. I have contacted Support numerous times, who simply keep telling me they are aware of the issue, and are not able to give me a resolution time. I feel I am being fobbed off here, as its nearly 4 months without Zapier. Where do I begin to start diagnosing the problem? Where is the debug console or logs, for me to investigate. I am truly desperate. Regards,Colin

5
E
2 years ago
M
meganfBeginner
asked in How Do I

Problems with account

Hi,I think there;s an issue with our accountWe paid for the starter account and according to the attached image it will reset on march 24th.However, my zap dashboard says everything is held until May 1st. Can someone tell me whats going on?Thanks This post has been edited to remove personal information. Please remember that the Community is a public forum and do not include private or personal information in your posts.

2
M
2 years ago
M
mohamad.idlepi@gmail.comNew
asked in How Do I

Zapier to send Case record to Azure DevOps

Hello,Im trying to build a ZAP to connect D365 CRM to Azure DevOps.when a new case/incident arrives to CRM365, I need to create automatically, a work item in Azure devOpsMy CRM365 is online (mycompanyname.crm4.dynamics.com/) hosted in Europe …I did not work with me . any help?Thanks

2
AndrewJDavison_Luhhu
2 years ago
D
dvisconteBeginner
asked in How Do I

Impossible to connect Wordpress to Zapier "/wp-json/zapier/v1/token"

Hey everyone,  Trying to connect a wordpress website to zapier.  Plugin well installed and well activated.  Specific account created  Still get this error message : “authentication failed: maximum redirect reached at: https://www.exemple.com//wp-json/zapier/v1/token” Do you have any idea how to solve this ? 🤙 Thank you !! 🥰

3
AndrewJDavison_Luhhu
2 years ago
B
bearguy904New
asked in How Do I

Quickbooks Online Payment Creation (Object Not Found)

Hi all, I’m new here and trying to create one of my first Zaps.   It seems pretty simple,  I have a form from Formsite that is collecting payment information for Invoices.   Once the invoice is paid with FormSite,  a Zap reads the information and sends it to Quickbooks Online.    All that is going well, I have a zap that is triggered by the result,  it looks up the invoice number in quickbooks and then goes to apply the payment.    When it tries to apply the payment I get an error message that says “Object Not Found”.    I’ve completed all the fields so I don’t know what I’m missing.   Can anyone shed some light on this?  

5
AndrewJDavison_Luhhu
2 years ago
D
DigitalBeginner
asked in How Do I

Zoho Subscriptions to QBO - Invalid Reference ID

I updated my Sales Receipt Zap to QBO and for the life of me I cannot find why I am getting the following error. I have attached the screen shots of the test. The data all seems to be populating correctly, but it doesn’t make it to QBO. When it does run… the data is incomplete. SetupTest Error 

5
AndrewJDavison_Luhhu
2 years ago
J
jmobergNew
asked in How Do I

Facebook to Instagram

I am using a 3rd Party content provider who automatically post to my business accounts: Twitter, LinkedIn, and Facebook. That provider does not have the ability to post directly to Instagram or my business Google Page. The provider is not hooked up with Zapier yet either. Is there a way, work around, to pull the post from my business Facebook page feed and publish it to Instagram and Google? Thanks!

2
AndrewJDavison_Luhhu
2 years ago
Terms & Conditions