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 Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

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.

Get Help

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

25090 Topics

danielajk
danielajkBeginner
asked in Troubleshooting

Integration MailerLite (Classic) - Hubspot

Dear Zapier community,I am trying to integrate MailerLite Classic with Hubspot. FYI, there is an existing integration between the two, but it only includes standard fields (name, email, etc.) that are synced between both sides. However, we have custom fields that we populate while collecting signups through a signup form in MailerLite. The issue is that all custom fields are not synced from MailerLite to Hubspot, only the standard fields.I have tried to set up a zap that will transfer all collected data to Hubspot but somehow the connection is missing. This is not a zap to find an existing contact in HS to update, for which you would need a contact ID, but a completely new contact that should automatically create a new id in Hubspot when creating the contact with all inputs from MailerLite. It seems like MailerLite generally does not set up any unique identifiers, so leaving the HS/ML integration and just updating an existing contact in Hubspot would probably not work due to the missin

1
christina.d
1 year ago
M
morneipBeginner
asked in Troubleshooting

Hubspot to Google My Business - Status Code 400 Bad Request

Hi,I have read through the other posts on GMB but was unable to find a solution.  I have a small estate agency (providing a service) with a single location on GMB.  I can connect with Zapier and complete the Location (required) field when trying to set up a zap.  My aim is to create a post when a deal in Hubspot reaches a certain Stage.  I keep getting an error.  The Deal should Trigger the Action.  The Action is not working.Status Code 400 Bad RequestLast updated: 3 years agoProblemYour Zap is likely to be missing a required field, or a field value wasn't in a recognized format. For example, if a field in your action step is expecting an email address, but the value given is a name, the app may return a 400 error.SolutionCheck that your fields are correctly set up and mapped to each other. After some digging on the forum, I see most people are having issues with their locations and the ownership of those locations.  I have just one location (that is showing in the drop down on the Tri

8
M
1 year ago
E
Eric CaldwellBeginner
asked in How Do I

Importing specific data from Shopify to Google Sheets

Hey everyone. Bit of a confusing problem.  I own a running store, and want to import only shoe sales from Shopify - Google sheets. I need to make some sort of filter, telling it to only import when it’s footwear, however, I cant seem to find a unique identifier for footwear. In Shopify there is product category, but that’s not an option within Zapiers Shopify integration. Secondly, let’s say I did get a unique identifier and it triggers the zap, Id need to find a way to exclude the other non shoe items in that order. Hoping someone can make a suggestion on a unique identifier I could use for shoe orders, and a way to exclude non shoe items from those orders as well. Maybe this is too specific to be done. Thanks in advance for the help - this community has been extremely helpful. 

2
Paolo
1 year ago
N
nellgBeginner
asked in Troubleshooting

"API key specified is invalid"

Hey everyone,Just getting started, doin my first test. I have Klaviyo and bookfunnel set up, with connections tested and getting green lights. Doing a simple test of when a subscriber adds to bookfunnel, that subscriber is sent to a klaviyo list.The zap sees the new subscriber but the add to klaviyo fails. The mapping looks correct (only email and name of klaviyo list are required). The error message I’m getting is “API key specified is invalid.” Uh, what? If the API keys were wrong, wouldn’t the apps not be connecting? Should I disconnect bookfunnel and klaviyo and start over?Thanks for the help!

10
Paolo
1 year ago
A
Anonymous
asked in How Do I

Copy Googlesheet in Drive folder and move it based on Google calendar-defined "deadline" (event)

Hello! I am very new to all of this and would greatly appreciate your help!Would it be feasible to use a Google calendar event to trigger copying of a Google sheet in a Drive folder to another folder?For example, an activity log (owned by Org P) is stored in group members A, B, and C “activity log” subfolders on a shared Google Drive. At 11:59 pm on DD-MM-YYYY (Google calendar), this would trigger a copy being made and sent to a “pending approvals” folder (for review by Org P; once approved, this would send the line items to a compiling spreadsheet with another zap).I tried setting this up as the following but I could not get it to work:-Matching event in a google calendar (search for “activity log due”)-Finding a folder in Google Drive (the problem may be here since nothing is directly related to the Google calendar event?)-Finding a file in said folder, making a copy to a “for approvals” folder. (The approval would trigger the next zap to create rows in a compiling spreadsheet. This 

1
Paolo
1 year ago
Troy Tessalone
Troy TessaloneZapier Expert
posted in How Do I

Lookup Tables - RESOURCES

Lookup Tables ConceptLookup tables make Zaps dynamic by allowing data to be translated between apps, and extra data points to be retrieved in a single step. BenefitsWhen using lookup tables in Zaps, it helps streamline the setup and support by reducing the number of similar Zaps needed, which means less points of failure, less maintenance, and less troubleshooting. Use CasesEXAMPLESTranslate Data United States to US or USA Find a related internal ID Find an email address and get the contact’s related phone number AppsZapier Tables Airtable Google Sheets Microsoft Excel Storage by Zapier Formatter > Utilities > Lookup Table Best for simple use cases ...and more Spreadsheet apps Database apps  TopicsSearch Zapier Community Topics related to Lookup Tables: https://community.zapier.com/search?q=lookup%20table

0
Troy Tessalone
1 year ago
therealkenobi
therealkenobiBeginner
asked in How Do I

How to extract the second value in an output array?

Trying to create a system that creates a new project and then adds a list of pre-configured to-do tasks. I can create the project fine, but creating the to-do list returns an error. To do this successfully, I need to have the ID value of the to-do dock. This changes for each project, so I can’t hard code it. The dock ID values returned by creating the project in the previous step come back in an array formatted as [A, B, C, D, E]. I need value B. How would I be able to extract that value so I can properly label it and create the to-do list?

2
therealkenobi
1 year ago
P
plyskeBeginner
asked in How Do I

Deleting a row in Excel should trigger the record in Airtable to either be deleted or moved

Hello everyone! So I want to make a Zap that fires when a row in Excel is deleted, and when it’s deleted the attached record in Airtable should be deleted as well (or moved). I’ve some idea about how to do it, but I’m quite unsure if it’s actually possible at all? 

6
nicksimard
1 year ago
E
ewagrosNew
asked in How Do I

How can I transform the accepted quotations from our prospects into orders on our Prestashop website?

Hello, we’re using Axonaut as a CRM, and we would like to transform the accepted quotations from our prospects into orders on our Prestashop website.Does someone know if it’s possible (I know that it’s not doable the straight way, but maybe there are some workarounds...) ?Thanks in advance for your helpCheers

3
christina.d
1 year ago
C
CarlLBeginner
asked in Troubleshooting

{{zap_meta_human_now}} gives correct time zone when testing but not in an actual zap

I am using {{zap_meta_human_now}} to update a date field in Airtable. I have my Profile Settings to America/New York for Eastern time.  When I test the action, the date and time “12/8/2022 2:30pm” is updated in Airtable. When the Zap runs from an actual trigger, it instead puts “12/8/2022 9:30am,” a 5 hour difference.  Any ideas why it works in the test function, but not in the live Zap?

5
christina.d
1 year ago
F
fionab2022New
asked in Troubleshooting

Jotform to Shipstation issue - The app returned "The request is invalid."

I am trying to link a jotform to ship station but keep getting this error.The app returned "The request is invalid.".I have checked the required fields and all are linked and tried to remove as much as possible. Any ideas of how to troubleshoot/fix

2
christina.d
1 year ago
M
MathiasNew
asked in Troubleshooting

Failed to create an upload file in Google Drive 'NoneType' object is not subscriptable

Hello I try to upload a Gmail attachement to a Google Drive. I have first setup a ‘New attachement in Gmail’ trigger, which works (and tests) fine. Then I try to upload the attachement to a Google drive, but this fails with the error Failed to create an upload file in Google Drive'NoneType' object is not subscriptable These are my settings: What is wrong with this? Thanks!

15
christina.d
1 year ago
I
IRetailBeginner
asked in Code & Webhooks

Integration with Business Central

Hi all,Is there any way, that we can redirect Webhook to a custom URL (in this case Dynamics Business Central API)?  Thank you

2
I
1 year ago
wyelsik
wyelsikBeginner
asked in How Do I

Zap for Duplicates in Airtable

I am looking for a Zap that finds duplicate unique values in an airtable table.   Employees participate in meetings and an entry is made in an airtable base.   Sometimes the program is completed more than once.  I am looking to flag those repeat meetings.   I do use DeDupe but looking for something that is more automatic. any help or templates would be great. 

5
Liz_Roberts
1 year ago
S
SpinozoneBeginner
asked in Troubleshooting

Create database item in Notion when Gmail message is labeled -- Body failed validation

Hi --I am trying to create a Zap which triggers when a certain label is applied to a Gmail message. This event would trigger the creation of a new Notion database item that includes the email’s subject, date, and body contents.I receive this error when testing:body failed validation: body.children[35].paragraph.children[0].code.language should be defined, instead was `undefined`.Screenshots attached.Thanks

4
rachael.silvano
1 year ago
L
Lida AriasNew
asked in Troubleshooting

Zaps with Hotmart and WooCommerce are not functioning

Hola!! Tenemos varios zaps activos con hotmart y woocomerce, los cuales estaban funcionando de forma correcta, de un momento a otro no están funcionando, pero la configuración me aparece correcta, ya consultamos con hotmart y nos dicen que el problema no es de ellos.Nos urge dar solución a ello porque esto nos ha afectado en gran manera.

3
rachael.silvano
1 year ago
J
jmclaughlinBeginner
asked in How Do I

How do I trigger a Zap when a salesforce record is deleted?

When an OrderItem is deleted in Salesforce I want to trigger a Zap that makes changes to a linked Google Sheet.  I tried a Zap that triggers when an OrderItem is updated and IsDeleted?=true, but it didn’t work.

1
Troy Tessalone
1 year ago
P
plyskeBeginner
asked in Troubleshooting

When updating Record in Airtable, Zap looks at the wrong Record ID

Hello everyone! So I’ve made a Zap that should make the Record update with a new Status based on the ticket status in Zendesk: The Zap will trigger when the ticket enters new View in Zendesk, in this instance ‘Solved tickets’I then have an Action that will find the Record in Airtable based on the Ticket ID from Zendesk. The Ticket ID is already added to the Records from another Zap hence this step should work. Then the Zap should Update the Record it found through the previous step where it matched Ticket ID from the Record with the ID from Zendesk. But here is the issue: When looking at ‘Record’ it takes the wrong Record ID from Airtable. I don’t understand how to fix this issue. The Record ID listed in this step belongs to a Record with another Ticket ID.  

1
Troy Tessalone
1 year ago
M
MrChipsBeginner
asked in How Do I

How to archive an email when it is opened/marked read in the Gmail inbox?

I tried to create a zap for processing an email once opened in the gmail inbox to archive it removing it from the inbox - any ideas?

13
M
1 year ago
C
CJABBeginner
asked in How Do I

Extract sheet from email and save to Google Drive

I wnat to extract an excel sheet from an email and save to google docs or other shared folder which I can sync to a server to process. I nkw I need email parser.  The email will arive to office 365 from a customer and contain an order. I may also need to parse data from the email and append to the spreadheet before saving. Can you provide a orkflow or example please?

6
rachael.silvano
1 year ago
C
celodrawsNew
asked in Troubleshooting

Typeform error: retrieving: CustomUser matching query does not exist.

Hello.I’m trying to create a zap connecting a Typeform and Gmail. But when I get to the Test Trigger step, I always get this error:Error while retrieving: CustomUser matching query does not exist.It is a new Typeform I’m working with, so I tried submitting a test entry on the form, but I’m still getting the same error.What can I do?

1
rachael.silvano
1 year ago
Santeri
SanteriBeginner
asked in How Do I

Am I able to choose which action gets triggered based on a specific stage?

The app I use has one trigger, but inside the app I can setup trigger on multiple different stages. 5 in total. I have multiple zaps for different stages. Am I able to choose which zap gets triggered when trigger gets sent from specific stage inside the app?

6
Santeri
1 year ago
C
canNew
asked in Troubleshooting

LinkedIn Gen Forms are not Added to Zoom

Hi there,I created an event with on my company page (I have Content Admin).And my manager used Zapier to connect the linkedin gen forms to Zoom.I created a workflow on HubSpot with the Event ID.But when people click Going on the event page it does not add attendees to Zoom.What might be the reason for this?Thank you,Can PS: i do not have access to my manager’s zapier account.Would this cause any issue?Thank you.  

2
rachael.silvano
1 year ago
P
Peter KBeginner
asked in Troubleshooting

Delay on instant trigger?

Hi! I have a problem with a PipeDrive trigger, the “Updated Deal Stage” which is supposed to be instant. Usually it has worked fine, but now it seems to have slowed down. In the case shown in the screenshot, the timestamp on the deal for the stage change time differs almost 3 hours for when the Zap ran. Does anyone have an idea of what could be causing this? Any help is appreciated :)  

3
P
1 year ago
M
Magdalena WilhelmBeginner
asked in How Do I

How do I send an email when a new Calendly appointment is booked in only one calendar?

Hello, I have a question. We have a Calendly account in the Professional version. I wanted to know if I could choose one of my calendars in Zapier. And if an appointment is booked in just this one calendar, an e-mail is triggered.  Currently I can't find what I see is that if an appointment is booked in any calendar in my organization, an email is triggered. How can I do this?

2
Danvers
1 year ago
Terms & Conditions