Skip to main content

Get Help

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

28200 Topics
B
bushrangNew
asked in How Do I
How do I tell the action "Lookup Spreadsheet Row in Google Sheets" to use the newly found file from step 1?

I have created one Zap that is looking for new Google sheet files in a Google Drive folder. Next, it should lookup for a spreadsheet row in the new file and transfer this data to another spreadsheet.The first step is working fine, but I can’t find out how to tell the second step (the lookup) to use the newly found file from step 1. The “Lookup Spreadsheet Row in Google Sheets” action only allows me to manually choose a file name from my Google drive and doesn’t seem to dynamically use the file name of the detected new file from step 1.Any help would be super appreciated 🙄 

2
jesse
2 years ago
K
kfsNew
asked in Troubleshooting
Error: email temporarily blocked

Hi,Have you ever come accross this error? What is it related to?All fields are entered correctly, tasks were run except for 1 that is returning an error. Would greatly appreciate your help!Thanks,Marta

2
Liz_Roberts
2 years ago
N
NOCBeginner
asked in How Do I
How to open a .jpg in Google Docs from Google Drive to get text (OCR)

I’m trying to take images of a handwritten document (which will be uploaded to a folder in Google Drive), open them in Google Docs, then pull the resulting OCR text into Google Sheets. The issue I’m facing is there isn’t an operation to “open” the file in Google Docs (from Drive or Docs integration). “Create a new file” doesn’t seem to be able to recognize any content (“no data”). So the workflow might be something like:File uploaded to Google DriveFile (.jpg) opened with Google Docs (which will OCR the image)New Row in Google Sheets with Text from resulting file(and then maybe other steps thereafter)If anyone has thoughts on how to accomplish this, please share. Thanks in advance!

2
N
2 years ago
D
DV_AutomationBeginner
asked in How Do I
How do I break a JSON response into line items?

Where did this feature code? it is no longer listed. Thank you I need to break a JSON respond to line items. thank youhttps://zapier.com/help/create/format/create-line-items-in-zaps

2
jesse
2 years ago
G
Gene FNew
asked in Troubleshooting
Teamhood error when authenticating: Only absolute URLs are supported

I’m getting this eror trying to connect to Teamhood and authenticating. Please help  Gene

2
christina.d
1 year ago
T
Tnance292New
asked in How Do I
zapier doesnt give me the option to select the email i want from incoming sales confirmations. its in one section of the body of the message.

I’m setting up a zap so when I get a sales confirmation email in gmail the customer email address gets added to a Flodesk segment.  When I’m setting it up and it prompts me to select the email I want in the tester, the email I want to grab is popped into a section with the body of the email.  Is there a way to separate that email out so I can set up my flow to grab my new customer emails?  

2
Danvers
2 years ago
M
mcbeyonceBeginner
asked in Troubleshooting
I'm unable to add "0" as a value in “Worksheet to Copy” in my Google Sheets action step.

Hello dear friends, Retaking this post from last year, I have exactly the same question/issue:How to copy a spreadsheet in another one when a file is added in a specific Google Drive folder?I followed the advice in the post, put 0 for “Worksheet to copy” in the 2nd step but as you can see in the screenshot below, it does not work and I cannot publish the zap. Any advice please? Have a nice day,David

2
Danvers
2 years ago
P
PurehardscapesNew
asked in Troubleshooting
No outbound calls are found when testing my Aircall trigger

I made an outbound call after adding the url to my aircall dashboard but no result is found after clicking on test trigger.What can I do about the delay?

2
Artyboi
1 year ago
J
joester1976New
asked in How Do I
Do I have to create a new Zap for each sheet or is there a way to set up a trigger for multiple sheets?

Hi all. So here is what I am trying to do. I have a Google Spreadsheet with a sheet A and a sheet B. What I would like to do is when Sheet A or Sheet B has a row added the Zap will send that info to a database.  How do I set up the trigger so that when data in either sheet is added the trigger is initiated. Currently when I use a google sheet as a trigger I can only select one sheet. Do I have to create a new zap for each sheet or is there a way to setup a trigger for multiple sheets?  

2
EJR
2 years ago
J
jakekahaneNew
asked in Troubleshooting
Facebook Lead ad to Kajabi Form Submission Error: The app returned "Unauthorized".

Trying to connect Facebook Lead Form to “Submit a Form Submission” in Kajabi. However, I’m getting the error,  Failed to create a submission in KajabiThe app returned "Unauthorized". Does anyone know what this is happening and how to fix?

2
jesse
1 year ago
K
KimFNew
asked in How Do I
Partial payment for course instructor from Kajabi

Hi! Looking for help here please- Kajabi (unlike other course platforms) don't automate the payment split between course contributors (instructors) and the course owner. It's currently a manual weekly calculation of percentage of turnover from the course inside kajabi less refunds, requesting an invoice and then processing payments form Xero.  Is there a way to automate this calc/ payment using zaps? Thanks in advance. KimF.

2
M
2 years ago
G
gal_adarrNew
asked in Troubleshooting
can't load the last trigger request

After a new version of Zapier a lot of my zap can't load the last trigger request, but the zap works well.Please help me to resolve this problem. Thanks!

2
MohSwellam
2 years ago
N
nikola miocinovicNew
asked in Troubleshooting
Google Meet start/end date and time is creating a meeting precisely 6 hours later than scheduled

I am trying to create a zap that creates a google meets meeting but, whatever time I input into the start date and time creates a meeting for exactly 6 hours later. I am working in London time so the time zone displayed is correct.   

2
N
2 years ago
C
catafsNew
asked in How Do I
How to post a Google Sheets Chart as an Image in template google doc

Hellopretty the same as these:I would like to add a chart to a google doc template  to replace a variable {{graph}} by the chart published image

2
jesse
1 year ago
C
capriversjonBeginner
asked in Code & Webhooks
POST to Zapier Webhook on Wordpress Page Load

Hi @Troy Tessalone Here is the scenario:Mailchimp Email campaign that has button which goes to thank you page on our site with URL parameter for the contact's email address. Extract the email from url parameter and then send to Zapier webhook to process my Zap (bringing that email along for the ride).This is a Wordpress site using Beaver Builder so I was hoping there was some way to nest some Javascript that can read the url parameter on page load and then POST over to Zapier webhook....is that even possible? Thanks! 

2
C
2 years ago
H
HostWiseCoNew
asked in How Do I
Zap to different email addresses based on a selection in Google Forms

Hi All - We have a team that does cleaning inspections for our properties. They go to a Google Form, select the name of the cleaner that executed the clean, then conduct the inspection. We use Form Publisher plug-in in Forms, which generates a PDF and emails it to Management. I’m currently using Zaps out of my email to then forward the PDF to the cleaner, based on the Subject (e.g. Cleaning Inspection Report For Frank Ricard).The problem - while this works, based on my current Zap structure, each Forward is a new Zap, and I’m approaching my 20 zap limit. I’d like to have some sort of “if / then” but I can’t figure out how to do this. Like, “If Subject = Frank Ricard, Then email Frankthetank@gmail.com. Or if the Subject = My Boy Blue, Then email “myboyblue@gmail.com.” That way I don’t have to keep increasing my Zap plan as my cleaning team continues to grow.Any ideas on how to do this, so I don’t have to continue increasing my Zap plan?

2
nicksimard
2 years ago
W
Walking ComfortBeginner
asked in How Do I
Manually Trigger Zap - Button or Otherwise

Hello, I am finding myself in a situation where an automated or scheduled trigger will not accomplish what is needed for a particular workflow. What I am finding is that I need a way to have a human trigger the Zap. I am not aware of the different interfaces Zapier has in this regard. I know I can use Zapier email to have the human send an message to trigger the Zap, but I was looking for something a bit more simple. Either a web addon button or something to that effect. Thank you so much kind people. I hope you have a wonderful week.

2
W
2 years ago
A
Anonymous
asked in How Do I
Can you use AND/OR with 'Extract Pattern'?

I’m making a zap where users will send a message in Discord including a time. The zap is meant to find that time and create a calendar event based on it. The only issue is that it’s hard to get people to use the exact correct time format to match the pattern I put in with Python Regex. This is what I currently have to match this format (00:00PM): \d\d:\d\d\w\w I’d like to have this search for multiple patterns: \d\d:\d\d\w\w OR \d:\d\d\w\w OR \d\d:\d\d\s\w\w OR \d\d:\d\d\s\w\w but it doesn’t seem the OR command is working. I would like to know if this is possible and if not, is there a workaround? Thanks!

2
A
2 years ago
N
nicolejadebNew
asked in How Do I
How do I set specific date filters for every day scheduele

Hi! I’m looking to re-stock certain products at midnight, on Mondays, Tuesdays, Wednesdays and Thursdays. However I can not work out how to block out Fridays as well as weekends? It’s giving limited values and I need to only allow the filter to update inventory on the above dates, not Fri, Sat, Sun.  

2
christina.d
2 years ago
A
amberrockeyNew
asked in How Do I
Form to Constant Contact - How do i update list if contact found + create contact if contact not found

I used paths to say “if they choose this option they go into this list, if they choose that option they go into that list” Works, sometimes. I have set as “Find or Create Contact” so it only works if I’m “creating a new contact” If it finds a contact, then it assumes the action is complete (and doesn’t update to include in the selected email list).Should I duplicate this Zap? One for Find or Create, the other for Update Contact?What is the right way to set this up? 

2
A
2 years ago
T
TMS MarketingNew
posted in Troubleshooting
New "Pushed Message" zap not locating trigger step

Split from Push to Zapier Slack trigger - not showing the modal to push a messageISSUE: I have connected slack to my zapier and I have added zapier to the Slack channels. When I create a new “Pushed Message” zap, it is not finding the trigger. I have tried private and public channels, both my and my colleagues Slack accounts, disconnected and reconnected the accounts, turned the zap on and off, deleted and retried-- NOTHING WORKS! It is showing a connection with the Slack account but it is not recognizing a trigger when I try to test.I have reached out to Slack and they told me it’s Zapier’s problem so PLEASE HELP. I need this to work or we’re in big trouble. Thanks,Jakexxx@xxxxxxxsolutions.comThis 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.

2
P
1 year ago
A
Apke landBeginner
asked in How Do I
Can I send reminder emails before a WooCommerce subscription ends when pending cancellation?

Hello!I am looking to set up an automatic reminder for when someones subscription is cancelling in woocommerce.Heres the flow im looking for. Member cancels subscription in woocommerce, they are then pending cancellation until their next resubscription date.They are emailed via zapier 14 days before their subscription ends, 7 days before, and 2 days before to try to recapture them. I hope this makes sense, if you have any extra questions I greatly appreciate the help!

2
chanelle
1 year ago
A
Anonymous
asked in Troubleshooting
Discord Rate Limiting Zap?

I have a zap set up to trigger on a message being sent in a specific Discord channel but every now and then I get an email saying the zap has errored citing “Being rate limited” I’m guessing from Discord. Here is the full error:Trigger partner failure: {"status":429,"headers":{"content-type":"application/json"},"content":"{\n \"global\": true, \n \"message\": \"You are being rate limited.\", \n \"retry_after\": 33\n}\n","request":{"url":"[url removed by me]}} Does anyone know why this is happening and how to fix it? It doesn’t seem like it’s breaking the zap or shutting it off so not a huge deal but I just want to make sure the zap doesn’t miss a message because it’s being rate limited.  Thanks!

2
M
2 years ago
Y
YehudiNew
asked in Troubleshooting
Google sheet fields are not updating

I create one zap which add a row in google spreadsheet when WPForm is submitted. I add 2 new columns to my sheet but those two new columns are not showing on my zap. I tried so many times to refresh zap and spreadsheet’s fields by clicking on refresh field but its not working!

2
A
1 year ago
J
JuliusNNew
asked in How Do I
How can I redirect to a "Thank you page" in ActiveCampaign when a person purchases on Acuity?

How to integrate Acuity to ActiveCampaign so when a person made a purchase on Acuity they will be redirected to a Thank You Page in ActiveCampaign?

2
EJR
2 years ago
Terms & Conditions