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.

25340 Topics

J
JoshuaANew
asked in Troubleshooting

Unable to transfer scheduled data from OneDrive to Google Sheets in my Zap.

transfers are scheduled but not running at all. I have a recurring transfer set up to pull from onedrive to google sheets and it only successfully ran once but although it is scheduled to run daily, it has never run since then. Why is this?

4
SamB
Community Manager
5 months ago
V
VovashBeginner
asked in Troubleshooting

Zapier is adding a new row far below the end of my Excel table

HI Everyone  I have small issue, I have an excel table which I set Zappier to update once task in Asana programme is complete, Everything works fine, but for some reason Zappier would add a new row far below where my table ends For example my table ends in row 40, but Zappier will add new row somewhere in 400. Does anyone know how to tackle this problem. I have tried to delete everything that wad below row 40 just incase I had some of the rows filled, but Zappier would still strart to add row  in a row number 400 instead of the end of the table. Thank you   

4
MohSwellam
1 year ago
S
Sven VermeulenNew
asked in Troubleshooting

Zapier can't find my Hub Planner projects or booking

HiI’m trying to setup a connection between Hub Planner and MS Teams so that whenever a new project is created, a new MS Teams channel is created as well (with the same name). I can’t manage to get the Hub Planner zap to properly connect to my Hub Planner. If I try to find a newly created booking, I get the “We couldn't find a booking”-error If I try to find newly created projects, it DOES manage to find two random projects, but not the once I had just added.So far I’ve checked (and double checked) the connection to my Hub Planner account with my read-write API key and made sure I’m logged into Hub Planner with the same e-mailadress as the one I use for Zapier (if that can even make a difference). EDIT: Tried generating a new read-write key, but that also didn’t work. What else could I try? ThanksSven

4
chanelle
1 year ago
E
Elliot LundBeginner
asked in How Do I

Return max value from airtable?

In Zapier, I’m trying to run an operation every hour that  adds a record representing +1 hour following the last previously created hour on our schedule (trying to do this on a rolling 3 week horizon). These are my calendar records. Every hour, I want to automatically add one after the highest reference #.I have reference numbers for a different purpose, but figure they’re the easiest way to approach this.I’m having trouble pointing Zapier at the highest “ref #” record.Find Record in AirtableIs my search formula off? It returns a record when testing, but not record 217. It’s returning Ref: 25.

4
E
1 year ago
C
charlesriverBeginner
asked in How Do I

Plaid Integration

Is there anyway one would be able to integrate their credit card transactions into google sheet via Plaid API or something similar? Trying to do a sync of credit transactions into a google sheet 

4
C
1 year ago
J
JavelinBeginner
asked in How Do I

How do I add files uploaded in Gravity Forms to the attachments area in a ZohoCRM lead using “Create Module Entry”?

Context: User fills out Gravity Form on website with their information and file uploads which then Zapier sends the info over to ZohoCRM creates a new lead and adds the files to the attachments area.Trying to add files uploaded in Gravity Forms (1-3 GF upload fields) to the attachments area in a ZohoCRM lead using “Create Module Entry” in Zapier.Anyone know how to do this?I can see there is another Zap type called “add attachment” to an existing lead..but I have no idea how to do a search and match it to the correct lead, if thats even possible all in the one Zap?

4
christina.d
1 year ago
B
BlakeChoisnetNew
asked in How Do I

How do I capture Facebook Group membership question responses?

I have a private FB group and I want to be able to capture the membership question responses and store that information in a google sheet. How can I do this? 

4
rachael.silvano
1 year ago
F
FinanzheldBeginner
asked in Troubleshooting

Pipedrive error: troubleshoot error 400 (bad request) in response and nothing is found

I have the problem that I simply want to find a lead in Pipedrive, while looking up for the persons ID. I always doing this with finding deals too. But I always get this troubleshoot error 400 (bad request) in response and nothing is found. But in Pipedrive everything looks fine. The contact is connected to the lead and the persons ID is also correct. By the way I tried to pull other IDs as well, I always get this response. Trigger: An invitee created an event on Calendly⬇️Find person in Pipedrive with email address ✅⬇️Find Lead in Pipedrive with the found contact (previous action) id❌ troubleshoot errorℹ️ If I use the title instead of the persons id, it works.▶ That's why, I think that the person's (contact’s) id field isn't working. Am I doing anything wrong? Thanks a lot,Nico This post has been edited by a moderator to remove personal or private information.

4
R
1 year ago
C
Chewy14Beginner
asked in How Do I

Add UTM's To A Link From A Google Sheet

Is there some way to add UTM’s or query string parameters to a URL within a zap from a Google Sheet? So if I had a new row in Google Sheets as the trigger could I create a URL in Zapier with columns mapped as the UTM’s or query strings on a specific URL?

4
jesse
1 year ago
Adeliand
AdeliandBeginner
asked in Troubleshooting

When MS Excel receives the information, it stores it as a string and not the usual “48587” format it uses to store date data.

Hello all,  I have a problem sending dates to an Excel spreadsheet, which would later be used as data for a pivot table. I have an app that sends infos such as date and time of delivery, and I know how to format this incoming data to something Excel can understand, such as 30/11/2022 (I work from France where date formatting is different).Problem is, when Excel receives the information, it stores it as a string and not the usual “48587” format it uses to store date data.It eventually means that my pivot tables don’t work the way I want them to, as I can’t sort anything by dates (Excel has an option to sort by “last month”, “next week”, etc that I want to use).  Bottom point is, Is there a way to make Zapier send dates data in a way Excel would recognize instantly ? like the 45848 or whatever ?  Thanks a lot!

4
Adeliand
1 year ago
S
saiCoachBeginner
posted in Code & Webhooks

Integrating Keap with google sheet with web hook

I have Google sheet working as a database to lookup columns into it.Campaign ID from Optin monter and some pdf url columns are into the google sheet.Now Trigger is web hook which is catching the request from google sheet and Action is finding the contact in Keap(InfusionSoft) and applying tag to it , So I have deliver PDF Link with tag through IFS.But that PDF Link(url) is not getting attached . How can i come up with the solution ?

4
S
1 year ago
P
Peter_KBeginner
asked in Troubleshooting

Zapier didn't trigger if the video is uploaded using Google Drive API

I'm Using standard zap “Upload new Google Drive videos to YouTube” the problem is when files in the Google Drive folder are uploaded using Google Drive API protocol. The Zappier ddint “see” them and no trigger. Any solutions ?

4
rachael.silvano
1 year ago
J
JoshCNSNew
asked in Troubleshooting

Followupboss Create Note Not Working

Any else experience that the followupboss crate note event is not creating the note in followupboss aswell?

4
J
1 year ago
B
B4TBeginner
asked in Troubleshooting

Error while retrieving: The app returned "Application Error". Error: Failed to fetch a message from Plivo

I am getting an error trying to set up a Plivo integration with my account. After enter the credentials for the Plivo account and tried to test the trigger, I am getting the following error.  “Failed to fetch a message from PlivoError while retrieving: The app returned "Application Error".“The system was able to fetch the phone numbers from Plivo, however was not able to retrieve text messages from PlivoTim

4
Liz_Roberts
1 year ago
J
jam223Beginner
asked in How Do I

Can we automate filling in HTML form fields and then submitting the form?

Is there a way with an app to send data from zapier to a website form and submit it? Eg some way to automate theporcess of filling in html form fields and then submitting the form.

4
christina.d
1 year ago
B
BorgesBeginner
asked in How Do I

I want to send scheduled, mass and personalized emails?

I am a teacher and I am responsible for several classrooms of students. I want to send scheduled, mass and personalized emails to the students of the different classrooms.  I am using the App "Every Day in Schedule by Zapier" and the App "Google Sheets", but I can't send the emails. I would like to know where I am going wrong.

4
rachael.silvano
1 year ago
K
kingcapitalNew
asked in How Do I

Rename new dropbox file to have the same name as it's containing folder

Is there a zap flow that would do the following:When a new file is added to dropbox, rename the file to have the same name as it’s containing folder.  So each new file should adopt it’s containing folder’s name. For anyone wondering, each folder will already have a unique name so there’s no issue of overwriting.

4
U
1 year ago
J
jonathanisaacNew
asked in Code & Webhooks

Extract Values from Text – BigCommerce Product Options

I’m trying to extract 3 values from BigCommerce custom product options. Each product will have these 3 options: Learner First Name  Learner Last Name Learner Email AddressI was able to use the “Extract Email Address” function in the Zapier Formatter, and that is working well. I’m having trouble extracting the other two values, though. The data is coming through like this: item_1:display_name: Learner First Namedisplay_name_customer: Learner First Namedisplay_name_merchant: Learner First Namedisplay_style:display_value: Jonathandisplay_value_customer: Jonathandisplay_value_merchant: Jonathanid: 16name: Learner First Nameoption_id: 33order_product_id: 17product_option_id: 155type: Text fieldvalue: Jonathandisplay_name: Learner Last Namedisplay_name_customer: Learner Last Namedisplay_name_merchant: Learner Last Namedisplay_style:display_value: Maydisplay_value_customer: Maydisplay_value_merchant: Mayid: 17name: Learner Last Nameoption_id: 34order_product_id: 17product_option_id: 156type:

4
J
1 year ago
A
ali_capoBeginner
asked in Troubleshooting

Zapier can´t find the subfolder of an S3 bucket

Hey,  I would like to copy newly created files within the subfolder of one of my S3 buckets to Google Drive.  Unfourtunately I can just see the S3 bucket but not the subfolders. If I upload any File in the S3 bucket or it´s subfolders, the Zapier doesn´t recognize it when I want to test the step.  Can anybody help me with that? 

4
Danvers
1 year ago
J
JP CollectiblesBeginner
asked in How Do I

How to automatically insert single sold item data from eBay to spreadsheet when buyers purchase multiple items at the same time.

When customer purchase items on eBay, the Zapier can automatically insert order data on the Spreadsheet. Hoewever, when buyers purchase multiple items, all items data are inserted to only 1 sell on the speadsheet. I would like to separately insert data. 

4
J
1 year ago
H
hand_in_handNew
asked in How Do I

How to See a List of All Our Zaps

My boss wants to review a list of all the Zaps we have in Zapier.How do I make, download, or export that information?

4
rachael.silvano
1 year ago
J
jordanstoichkovsmilegalaxyBeginner
asked in Code & Webhooks

Update Google Contact field with empty data

I need to update Google Contact from our CMS through Zapier Webhook. I have created the hook and sends data from our CMS. If the field is not empty it works. But if some field is empty the zap do not update this Google Contact field.EXAMPLEData in Google Contact:Name: JordanFamily: StoichkovPhone: 999999Data send from CMS with webhook:Name: JordanFamily:Phone: 0123312Result: The zap updates Name and Phone field, but not Family because it is emplty and new Contact data is: Name: JordanFamily: StoichkovPhone: 0123312Expected result is:Name: JordanFamily:Phone: 0123312I have tried Formatter step with default value, spreadsheets formulas but every time if the data field is empty (nodata) it is not send to clear Google Contacts field.

4
J
1 year ago
M
Mrs LewisNew
asked in How Do I

How do I add a WooCommerce buyer as a new lead to an existing list in Kartra?

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.

4
chanelle
1 year ago
L
LMVBeginner
asked in Troubleshooting

Error: Failed to create an offer grant in Kajabi. The app returned "email: is already taken."

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.I have a zap I would like to connect to Shopify to Kajabi. However, when I test it, it shows this error. I am trying to connect this zap so that I can have my course available for access for Black Friday. Please help!!!If you need more context or screenshots I can share more. - Thanks in advance. 

4
nicksimard
1 year ago
S
sergiNew
asked in How Do I

Create Lead in Pipedrive from FreshDesk with Specific Ticket

Hey all! Any ideas on it? How do I create a Lead in Pipedrive from FreshDesk with a Specific Ticket? Not every triggered action. Just a specific ticket existing in FreshDesk turn into Pipedrive Lead? Any help appreciate!

4
chanelle
1 year ago
Terms & Conditions