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.

Get Help

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

25083 Topics

H
HalcyonNew
asked in How Do I

How to update linked value for most recently created record in Airtable?

I need help finding the most recent record in a given table with zapier. I’m trying to use zapier to create a default value which links to another table. Here’s an example:MembersFirst Name Link Last Modified Alice . August 15th Bob . August 17th Charlie   August 19th  Members RollupName Members Link . Alice, Bob      Here’s what I’m trying to do:Whenever a new record is added to the Members table, I want to start the zap I then want to find and update the same record that kicked off the zap — in others, the one with the most recent “last modified” time (“Charlie” in the example above) Finally, I want to update the “link” field with “.” — which is the only record in the Members Rollup table.Right now, I’m structuring the zap like this:<TRIGGER> New record is created in Members<FIND RECORD> (need to find the most recently created record in Members) « this is where I’m stuck<UPDATE LINK FIELD IN THAT RECORD>  Thanks for the help!

3
SamB
Community Manager
2 years ago
S
samholland00New
asked in How Do I

Grouped Google My Business locations not available to select

This post was split from the topic: Google My Business Review Multiple Locations IssueHave a similar problem to this person. we have dozens over locations and they are grouped into two GMB groups. zapier doesn’t display any locations to select in the zap.  

4
SamB
Community Manager
2 years ago
L
laneyeavlyBeginner
asked in How Do I

Acuity Scheduling appointments not added into Monday.com - “invalid value” error

Hi, I've been trying to setup this integration appointment scheduled in acuity scheduling > create new item in monday.com. After entering the column values in the fields to the left, and entering in the information that I need in JSON format in the right fields. After I’ve setup the zap and test it out, I either get an error message that says “invalid value” or the item is never created. I’ve contacted the Zapier team and the Monday.com team and neither have been helpful. I’m hoping someone from this community can help! Thanks

7
Troy Tessalone
2 years ago
J
Joseph.wintersBeginner
asked in How Do I

Kixie Send SMS “Cannot read property 'length' of null” error

I am receiving the following error in my Send SMS through Kixie step. It’ started out of nowhere and is now affecting all 30+ of my zaps I use this feature on. any help would be great.  it says “successful” however, nothing actually goes through. I reached out to kixie, they had their support do a screen share and they said its not a problem on their end, had no clue what could be the issue.   TypeErrorerrorMessageCannot read property 'length' of nulltrace1TypeError: Cannot read property 'length' of null2at Query.<anonymous> (/var/task/SendSmsApi.js:475:31)3at Query.<anonymous> (/opt/nodejs/node_modules/mysql/lib/Connection.js:526:10)4at Query._callback (/opt/nodejs/node_modules/mysql/lib/Connection.js:488:16)5at Query.Sequence.end (/opt/nodejs/node_modules/mysql/lib/protocol/sequences/Sequence.js:83:24)6at Query._handleFinalResultPacket (/opt/nodejs/node_modules/mysql/lib/protocol/sequences/Query.js:149:8)7at Query.OkPacket (/opt/nodejs/node_modules/mysql/lib/protocol/sequ

2
J
2 years ago
G
GM-AxiellBeginner
asked in How Do I

How to automate new and updated leads and opportunities between Dynamics and SharpSpring?

Hello, I’m looking to see if anyone in this community has used Zapier to connect Dynamics CRM and Sharpspring marketing automation platform. I’m looking for help putting together my Zaps to bring data between the platforms and would love to connect with individuals who have experience doing this. I’m looking to: Send new leads from Sharpspring into Dynamics  Update leads in Sharpspring as sales members contact them and update them in Dynamics Send new opportunities from Dynamics into Sharpspring Update opportunities in Sharpspring as they progress through Dynamics Please let me know, thanks! 

1
Troy Tessalone
2 years ago
D
Diego0_12New
asked in How Do I

How to bill my company for the Starter Plan subscription?

Hello, I nee ur help because recently i´ve paid de Starter Plan Subscription for my company and I need to bill them. Did anybody knows how can i ask for? Thanks

3
Troy Tessalone
2 years ago
A
Andrei SNew
asked in How Do I

Discord “Invalid Webhook Token” error

HelloI’m gonna integrate confluence cloud and discord.But I’m getting this error every time.message: Invalid Webhook Tokencode: 50027Please help me.Thanks.

1
Troy Tessalone
2 years ago
O
olivierBeginner
asked in How Do I

Images from Airtable not appearing on Linkedin posts?

Hello, I can't post the images from my airtable on a linkedin account. Is it possible?

4
Troy Tessalone
2 years ago
D
Dustin GurleyNew
asked in How Do I

How to mirror changes in one Google Sheets spreadsheet to another?

I have duplicated a Google sheets sheet (Sheet A) to another Google sheets sheet (Sheet B). I am trying to duplicate any changes in Sheet A to Sheet B. This seems like it would be super easy but I am running into issues. I am able to update a single row or copy a new sheet upon changes but I just want to simply Mirror Sheet A to Sheet B. Will someone provide a link or a provide a guide?Thank you. 

4
D
2 years ago
Panda Workforce
Panda WorkforceBeginner
asked in Code & Webhooks

Possible to connect to UKG (UltiPro) API using Webhooks by Zapier?

 Quick question.  Has anyone setup a Webhook for UKG (UltiPro)?

4
Panda Workforce
2 years ago
A
Adi SheferBeginner
asked in How Do I

Gong not supplying Account Crm Ids to Salesforce - search value always empty

Hi!I try to do integration between Gong to Salesforce and I’m not sure if this is correct:I want to map the account id  from Gong to Salesforce, but when I do tests - the search value is empty Also, I want to find the specific contact - and I see this option, but the search value is also empty:   

1
robschmidt
2 years ago
A
Alex_ekhlassBeginner
asked in How Do I

How to automatically delete entire spreadsheet with Google Sheets?

I ahave been workin on this for a while, The idea is to export the order (.xls) from woocommerce to google sheet daily.I want to export this daily. Meaning, there will be new tabs created everyday for daily export sheet.Example: on 15th August, zapier will automatically export the excell order sheet from woocommerce and import it to google sheets under a single tab. On the 16th August, the same process will happen but i want zapier to import the order sheet onto a new tab. Therefore, by the end of the month, i will have 1 tab for each day (1 tab for 1 order sheet daily)I have figured out a way to go around this. 1. At 12:05 am, zapier will export the order sheets (from woocommerce) into google spreadsheet(secondary).2. Then, zapier will copy the whole spreadsheet onto the another google spreadsheet(main). this google spreadsheet(main) is created so that zapier can create new tabs daily in that spreadsheet.3. The next day, zapier will go through the whole process but when it comes to th

1
Troy Tessalone
2 years ago
V
vdelafuente
asked in How Do I

Not receiving replies from Zapier Support team

In the last few months I encountered different issues and only one was it’s solved and thanks to the community forum but not the support center.MS Dynamics connections: solved by the community because I was added on the loop of affected users now I have two problems with zero support at all:I can’t activate a MS Dynamics even without reaching the max. premium apps for my plan an app that is connected with zaps lived now dissappeared from “my apps” section for both isues there were tickets opened through the contact form but no reply. 

8
R
2 years ago
M
Minoru NemotoNew
asked in How Do I

Freshping “JSON results array could not be loaded” error

There was an update in Freshping on 2021/08/17 and the payload of the webhook was changed to v2.I don't know if this is the cause, but I can't create an Integration with Freshping as the trigger.The following error is displayed. Are there any plans to support this issue?

2
M
2 years ago
K
KPetersenNew
asked in How Do I

How to create Excel file from template?

Hi all, I’m testing Zapier to connect GoCanvas (form builder app) and Excel online.  The goal is each time a submission is received it will create a new Excel file based on a pre-formatted template with unique file name. So far I’ve successfully achieved creating a new Excel file and unique name, but I can’t figure out how to get any sort of auto formatting or template happening.  The template would have a job summary section at the top where it details client name, address etc which would populate from certain fields and then a table below where inventory items are listed, populating from other fields. Is this something I can do with Zapier, or should I be looking to something like Power Automate in 365 to perform the formatting step? Thanks in advance for reading!

1
Troy Tessalone
2 years ago
J
Jon MurphyBeginner
asked in How Do I

Quickbooks "Could not connect to your account" OAuth2 Error

Hello, I’m seeing the attached error when I set up OAuth2 for quickbooks within zapier I used the same setup as the following user: Setup Quickbooks OAuth2 on Zapier | Zapier Community Any idea what causes this issue? 

4
christina.d
2 years ago
L
lynnmonkBeginner
asked in How Do I

How to use Zapier to connect to a cloud server app that isn't listed?

I use a cloud server that isn’t listed and I need to find a way that my colleagues can upload to it. They currently upload to a folder on Google Drive, so it would help if I could detect new files then automatically copy or move them to a folder on my server. Thus keeping the Google folder free for more new files. My server does have API integration for uploads but I have no idea how to program an API script.

8
SamB
Community Manager
2 years ago
L
lpy206New
asked in How Do I

How can you sync files added in Box folder to Frame.io?

I have a trigger set up that when I create a folder in BOX, it also creates it in Frame.io with the same name. How can I add a new trigger that when a file is added to that BOX folder, it also syncs inside Frame.io? Is this a function that I can only get with a paid plan? Thanks in advance!

1
Troy Tessalone
2 years ago
D
Daniel MalsjoNew
asked in How Do I

How to change data being sent from Facebook Lead Ads to Google Sheets?

HiI have created a Zap from Facebook lead to google sheet, when I did this I selected only a few of the colums to be shown. Now I want to change it so more colums/data is being shown in google sheet.How do I change this? Thanks a lot // aka Beginner  

1
Troy Tessalone
2 years ago
M
marianaoliveiraNew
asked in How Do I

Email Parser CSV attachments - “Daily Limit for Unauthenticated Use Exceeded. Continued use requires signup” error

Hi! This is my workflow -- I receive a .csv file export via email and upload it to Google Drive. It has around 11mb, and the file is uploaded successfuly, but the .csv upload in the Drive get stuck around 1.4mb (15001 rows). I see this error from the Google API… does anyone know how I could troubleshoot it? "code": 403, "message": "Daily Limit for Unauthenticated Use Exceeded. Continued use requires signup."  

5
jesse
1 year ago
L
LoveleenNew
asked in How Do I

Zaps disappeared and account plan changed

Hi,  I logged into Zapier and found that all my previous zaps disappeared and my account went back to professional trial from paid. I saw the other community post, but the solution didn’t work in my case. I also can’t see the history for previous zaps that I created. Can anyone please let me know what could be the issue here? 

4
L
2 years ago
S
seabiscuitNew
asked in How Do I

How to trigger Constant Contact campaign if no reply to Outlook email after 3 days?

I would like to trigger a drip campaign in constant contact if there is no reply to an email for three days. We send quotes to potential clients that fill out a form on our website. We would like to start a drip campaign if the potential client does not respond to this email after 3 days. The emails are sent from outlook. We have a zap that creates a contact in outlook once a form is filled out in gravity forms. Also when someone fills out a form in gravity forms it creates a contact in constant contact. When this contact does not respond to the quote we would like to start a drip campaign in constant contact the educates the client about our services. Is this possible with Zapier?

1
Troy Tessalone
2 years ago
A
akrausNew
asked in How Do I

SocialPilot “Cannot read property 'length' of undefined” error

I have created a custom trigger that copies posts from my website’s blog to Social Pilot. The trigger has been working fine until last week. I have just noticed that it is giving me the error: Cannot read property 'length' of undefined. The Zap’s RUN ID is: 0090f337-49bc-a6a9-ac12-43ca10536391In the Data In section it is showing:group_id:801ff2bc-5ae1-4b34-bbac-0923fbf2875daccount_id:1:1105219post_content:Tennis Ball VacuumA Design Story – Tennis Ball VacuumHi folks, I’m Walter Wardrop, an Operations Management Coach at the Growth Roundtable. Many years ago, I was called on to help a company that had an issue with the product they had designed. The company had come up with an item that was meant to go on top of the plastic container that usually holds three tennis balls. The concept was to put the balls back in the tube/can, then seal and evacuate the air from the can. This would help to store the balls in a better condition, and result in the balls lasting longer before they lost

7
jesse
1 year ago
Y
YitzEBeginner
asked in How Do I

Export email attachment data into Google Sheets

Hi All,I’m constantly downloading reports and using them to replace data on Google sheets. If I were to get the report to show up in my Gmail inbox, does anyone know how I can automate the process so that the attachment file is automatically used to replace Google Sheets data? 

6
Y
2 years ago
A
a.savchenkoNew
asked in How Do I

Zap not transferring all data from Notion to amoCRM

Hello everyone!Im in dare need of any kind of asistance or advice. My zap does not really work well: https://zapier.com/shared/81ec85cee07dcb82530d2211a6d44bad8d47fcc5I tried to syncronize my Notion and amoCRM databases. However each time zap runs it does not really transfer all the data I require. There is no visible pattern of why Zapier cuts it.Does anyone have any experience in making Notion + amo zaps?

1
Troy Tessalone
2 years ago
Terms & Conditions