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.

25659 Topics

A
AtillaBeginner
asked in How Do I

How to create new Google Sheets with Zapier

Hello dear community,I've been looking for a solution to a problem for a long time. Maybe you can help me here. The point is that we use Hubspot as a CRM. But we create our offers using an Excel file. Because that is where our calculations etc. included. In our earlier CRM we had a button which we pressed which then imported all the data into our Excel file via a macro. So a new Excel file was created and all information from the customer was inserted directly.Do you think it is possible to trigger something via any Zap? So copy this Excel file (can also be Google Sheets) and add all customer information.With which app could we solve this?We would appreciate any food for thought.

5
SamB
Community Manager
2 years ago
L
Luan VExpensesNew
asked in Troubleshooting

Wix ID field missing from test sample

Hi all!I have a Zap from my Wix Automation Rule which brings fields from my Wix Forms to my marketing automation platform. One of the fields that I am trying to send is the form submission unique ID provided by Wix. However, this field is not sending data, despite it’s currently showing at the moment that I am creating the Zap. Why this field is not working? Can someone help me?PS: I already tested. 

5
Troy Tessalone
2 years ago
M
mariodiceBeginner
asked in How Do I

How can I upload Google sheet to FTP?

HelloThanks for reading. My Zapier is creating Google sheet, But I want to export that Google sheet to my FTP. Can anyone tell how can I do it? Thanks

5
Troy Tessalone
2 years ago
A
AdamZapBeginner
asked in How Do I

Downloading HTML via Zapier

I am looking to save a complete page (with CSS, images, fonts, frames, etc.) as a single HTML file similar to singlefile. Is there any service in the Zapier ecosystem that can do this. The use case is that I have a google sheet of URL’s and I want to have each url saved as an html file. Adam

5
Troy Tessalone
2 years ago
W
whatlieBeginner
asked in How Do I

eBay - Xero: How to use Formatter to properly manipulate input

Hi all New to Zapier, I have a zap setup to take customer orders from eBay and then out to Xero. The data does need manipulating through the Zapier Utility.If have the following issue:Data in eBay: Sold for £25.99, quantity 2, total price: £51.98Zapier Utility: Sold for £51.98, quantity 2Xero Invoice: Sold for 51.98, quantity 2, total price: £103.96I guess this is an eBay issue but I thought I would try here first.Has anyone hit this or have a solution? 

5
jayeshkumarbhatia
2 years ago
P
Pim BaljonBeginner
asked in How Do I

Possible to only continue Zap when Asana task is complete?

Hi all! I have created the following zap: Fill out google form Form data is put into a google sheet Delay until 06:00 in the morning At 05:00 in the morning parabola does some google sheet restructuring and fills in the blanks Google doc is populated from template Task is created in Asana for approval An e-mail is sent out as a notification to check the Asana task Only continue if... Asana complete is true (so if we have completed the task) <- this is the tricky part Generate and attach pdf and send out to the right person.This is all instant, so the moment the Asana task is created and I should be checking, the zap already continues and concludes that the Asana task is not completed. So the zap run stops. Once I have completed the Asana task it doesn't continue, because it would have to re-run the whole zap. The only solution I can think of is to put a delay in there for about a day to have the time to check on an Asana task, but that's not productive for me. Is there a way to have

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

New task in Asana to Google Sheets

Hi there! We’ve been using Zapier for a quite some time for transferring data from Asana to Google Sheets. The process is simple. We’ve got several projects: one project for one legal entity. We also configured two ZAPs fro each project:New Row - this Zap adds a new row to a Google Sheet when there is a new task added to the project Update Row - this Zap takes ID of the task, looks through the column with IDs on a specific Google Sheet (the one, where first Zap pastes the data), identifies required row and updates it every time the task itself is being updated. The process is very simple and straightforward. Today for some reason all our “New row” tasks for 5 projects stopped working all at once. At the same time we literally did not change a thing! In order to fix the problem we tired the following:Log out and log in: Zapier, Asana, Gmail Test trigger and test action for each “New row” Zap - everything works fine. Trigger says “we found a task!” and Action successfully adds a new row

5
Troy Tessalone
2 years ago
Jarno Kylander
Jarno KylanderBeginner
asked in How Do I

Woocommerce order from Hubspot deal stage change

Hi, I’m trying to automate a woocommerce order creation from a Hubspot deal stage change.The problem is that Zapier only sees the properties of the deal, not any of the company that the deal is connected to.Is there any way for Zapier to see more data than just the deal’s properties?The order in Woocommerce needs at least the company name and address.

5
Jarno Kylander
2 years ago
A
Amy HWBNew
asked in Troubleshooting

Facebook Offline Conversions “You can't use offline event sets until the terms of service are accepted for COMPANY” error

Hi there, I am trying to set up Shopify, Facebook Offline Events Conversions. Every time I run a test, I keep getting this message:The app returned `{"message":"You can't use offline event sets until the terms of service are accepted for COMPANY. Please accept the terms of service at https://business.facebook.com/events_manager2/?business_id=BUSINESSID&data_source_i But when I click on the link, there is NO TERMS to be accepted. What do I need to do to get this working?

5
jesse
2 years ago
K
Kalps.bBeginner
asked in How Do I

Updating an already found TeamUp Calendar Event with a value from an Excel sheet

Hi All, I would appreciate any help you can give me with this, please… I have created a Zap with the following:Trigger: Event Start in TeamUp CalendarAction: Find Row in ExcelAction: Update Event in TeamUp Calendar Basically I want to find the TeamUp calendar event using the initial trigger - which works fineI then want to find a corresponding row in an Excel sheet - which also works fineHowever I then want to update the TeamUp event with a value from the Excel Sheet - I don’t know quite how to achieve this?Any input or guidance would really be appreciated.  Thank You.Kalps

5
Troy Tessalone
2 years ago
Y
YidiBeginner
asked in How Do I

Validate/Extract US address from a Google Sheet cell

I was looking for a way to extract/validate a US address in a single Google sheet cell. 

5
Troy Tessalone
2 years ago
S
so-zap101Beginner
asked in Code & Webhooks

Raw Webhook - Run Javascript error: Cannot read property of undefined

I believe I nearly have this script working. I have two zap events, the first is a Catch Raw Hook event that successfully captures raw JSON from a webhook, the second is a Run Javascript event. The script works as intended, but I believe I am not correctly defining inputData at the beginning of the script, hence the error. This may be something simple I am overlooking, any guidance is appreciated!The JSON being output from the Catch Raw Hook Event is as follows:[{"testJSON":{"testfield1":"test","testfield2":"test","testfield3":"test","testfield4":1,"testfield5":"0","testfield6":"0","testfield7":"test","zipCode":"90210","city":"testfield8","testfield9":"test","testfield10":"testfield10","testfield11":"test","testfield12":"test","testfield13":"test"},"events":"2021-10-04\nPage visit 09:50:00\n - URL: google.com/testing123\nPage visit 09:55:50\n - URL: google.com/testing456\nPage visit 09:52:03\n - URL: google.com/testing789\n\n2021-11-04\nPage visit 13:40:03\n - URL: google.com/blah\n\n"

5
Troy Tessalone
2 years ago
G
gchakyBeginner
asked in Troubleshooting

Subscriber Zap Not working between Mighty Networks and Moosend

I set up a zap with a trigger of a new member in Mighty Networks to an action by Moosend to add it to a mail list. It works on the “automatic test” but that is the only place it works. No activity when someone joins the Mighty Network at all in Moosend. Thank you!

5
G
2 years ago
S
SerrePipeNew
asked in How Do I

Convert text into numbers in Google Sheets

Hi there,Do you know hoe to convert text into numbers in Google Sheet ?I try to export orders from Woocommerce to GS, in rows, but number are converted automatically to text, so i can not manage numbers in GS ! I’ve tried to switch format in GS, i’ve tried to numerous filter, but it end it stay text and not number. Thank you so much, i’ve search in forum and on google and coulnt find any answer to this basic problem.Regards

5
S
2 years ago
R
ryokuroNew
asked in How Do I

Zap was run so many times unintentionally

Hi, I’m using Zapier Schedule trigger and trying to run a zap to send Slack message once in an hour.In my test, it always works fine and confirmed I received Slack message. But once I enabled the zap, zap was run so many times in an hour (over 100 times). The trigger runs once in an hour. ← this is expected ! But runs so many times.e.g. At 1 PM, zap runs over 100 times and it continues one or two minutes then the same thing happens at 2 PM as well. How can I solve the problem? or is this a bug of Zapier? Image: the same zap run at the same time. I used my free account quota by this lol.

5
SamB
Community Manager
2 years ago
T
Thomas2MBeginner
asked in Code & Webhooks

Convert minutes to hh:mm:ss with code

Hello, I have a field coming from an app expressed in minutes and needs to format it into an hh:mm:ss format.I could not find that option in date/time formatter so I’m trying with a Code by Zapier step.I want a value such as 60 to become 01:00:00 or let’s say 90 would become 01:30:00, etc... I have no preference for python or JS, whichever one works will do, Looking forward to reading your ideas.Cheers,Thomas

5
SamB
Community Manager
2 years ago
P
PeperitNew
asked in How Do I

- Google Sheets to Notion 2-way sync - Lookup Spreadsheet Row unable to find match

Good morning everyone, I’m struggling to set up my Zapier, I would like to have a 2-way synch between Google Sheets and Notion. I was able to to set the Google Sheets to Notion Zap but I can’t do the same for the other way around.I already checked for sharing permissions and compatibility (so went through the Token process and everything) but what stops me is the Lookup Spreadsheet Row.What I want to do is having one column (if not the entire file) sending the input from Notion to Google Sheets.Is there anyway to solve this? Zap blocksError in the Lookup (2nd step)File on SheetsFile on Notion 

5
jboyski
2 years ago
O
odinBeginner
asked in How Do I

Is it possible to only ping a specific group when posting to a Discord channel?

I am trying to tag a certain discord group when Zapier post an announcement about a new post from my Ghost site. I can post default groups like @here and @everyone, but I don’t want to ping everyone. I only want to ping those that elect for it. Anyone know how to fix this?

5
christina.d
1 year ago
C
ChipGeBeginner
asked in Troubleshooting

'New file in folder' Dropbox trigger not uploading to YouTube

Hello,I an trying to create a workflow where I upload my videos from DropBox directly to YouTube, essentially by-passing my computer when I have bad internet. (My video editor delivers the video to Dropbox).I created a Zap with the the trigger “new file in folder” (dropbox) and the first test worked, it did get uploaded to YouTube, but if I delete that file and replace it with a new one it doesn't get trigger again. Is there a way to make zapier see that there is a new file there and upload it YT?Or maybe manually trigger it somehow? Would I have to re-create the Zap every time I upload a video?Thank you!Chip

5
C
2 years ago
E
edweissBeginner
asked in How Do I

Zoom webinar registration with dynamic meeting ID

As far as I can tell, it’s been over a year since the last update about the difficulty in creating new webinar registrants in Zoom using a dynamic meeting ID.  Any timeline for when this will be fixed? This is really a very basic feature to not have working properly!  Ed

5
christina.d
1 year ago
L
LiPiBeginner
asked in How Do I

Google Drive action - how do I filter by PDF attachments?

I have a zap to store PDF documents attached to GMail mails:Trigger is new attachment in GMail → works fine. Filter if Attachment mime type is application/pdf → works fine, only mails with PDF attachments are left. Upload attachment to GDrive → if a mail has a PDF attachment AND any other attachment, all are saved to GDrive. How can I only save the PDF attachments?

5
Troy Tessalone
2 years ago
W
WataruNew
asked in How Do I

Bubble does not work - The app returned "Invalid refresh_token” error

Hi.I connected Shopify & Bubble with Zapier. It was working properly before, but now it does not work with the following error message at the Bubble step. The app returned "Invalid refresh_token: 9b68e3b11455429da07fad0d273386a3". We didn’t change the Shopify nor Bubble at all… Thanks 

5
X
2 years ago
T
terrillNew
asked in How Do I

Sendinblue “Error (400) undefined” error

I am trying to integrate with SendinBue and keep getting an error 400 Please advise Thank youT  

5
Troy Tessalone
2 years ago
J
john-jackBeginner
asked in How Do I

Passing a a string as a literal

I’m not sure if I’m even characterizing my question correctly. Here is the situation:I want my Zap to send the string {{Date:DDD}} to a text file in Google Drive. From there, I have an desktop automation that transforms it into a markdown file which is ingested by Obsidian.md. The problem is that Zapier uses the double brackets to indicate an internal field within the Zap. Thus it returns “No Data” and doesn’t pass the string to the text file I’ve tried to use backslashes (e.g. \{\{ and \}\} ) but then all I get is “Date:DD” passed to the text file. I get the same result when enclosing the string in quote marks.Does anyone know how I can get the desired string into the text file without Zapier processing it as an internal field? Thanks!Jack

5
Troy Tessalone
2 years ago
J
jelgieBeginner
asked in How Do I

How do I create a variable that I can use across my Zaps?

In particular, I’m trying to make it so that a person’s name is applied across zaps, but I don’t want to type that name in each Zap because I may have to change it in the future.  Thank you!

5
Troy Tessalone
2 years ago
Terms & Conditions