Skip to main content

Get Help

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

28578 Topics
T
traker998New
asked in How Do I
FreshDesk to PandaDoc

Hello,   We are trying to improve our workflow from FreshDesk to PandaDoc and it currently doesnt work exactly how we want it to however Zapier has given us the information needed to complete the workflow but not speficially how to do it.   Obviously a paid position.  I think it is kinda simple but I always think that.

1
AndrewJDavison_Luhhu
4 years ago
J
jecNew
asked in How Do I
Extracting a new lead name from an email

I’m working through a new ZAP. New leads (O365 email) trigger will eventually to create a contact and initiate a lead intake workflow: Office 365 email hits Lead Folder Formatter I’m trying to extract the lead name (not email address, that would make life so easy) from the content of the email address. Once I’ve isolated the leads name, I’d like to verify that lead with our CRM wealthbox, (Find/ create contact) From there, I’d like to start a workflow within wealthbox to intake the lead. Can you advise a best practice that allows us to gather just the new lead name data in an HTML formatted email? Thank you!  

3
Danvers
3 years ago
M
MorisonBeginner
asked in How Do I
How to generate date in google sheets?

Hi, how to generate date and time in a row in google sheets? I need a date when specific lead was sent (saved) in google sheet. How to do it?BestM

2
M
4 years ago
E
ericgTinkerer
asked in Code & Webhooks
Can I use URL query parameters in a catch webhook's URL?

Was just reading this post on the Zapier blog and now I have a question. Would I be able to configure a QR code to point to a Zapier webhook and also include some URL query parameters at the end? And would those values be available later in my Zap?If so, I could do some neat things. The post mentions collecting data for the Zap by pointing the QR to a form. In my hypothetical use-case, I might already know the scanning individual’s name. Rather than ask for it again, I could pass it via parameter.

7
MathiasRonin
1 year ago
joep87
joep87Beginner
asked in Troubleshooting
Google BigQuery error: Value of type STRING cannot be assigned to invoice_amount, which has type NUMERIC at [1:195]

Hi,Hope you guys can help out. I’m trying to update an existing Google Bigquery table using this schema:When creating a Zap to update the table i’m getting an error when updating the numeric field ‘invoice_amount:The value of this field is ‘9.99’ which shouldn’t be a problem. I have the same error when writing to timestamp fields.You guys have any ideas what is causing this issue an how to solve it?Thanks in advance!

8
SamB
Community Manager
3 months ago
J
Jan-SebastianBeginner
asked in How Do I
Find Spotify Song from URL

Hi everyone, I have a Google Sheet where URLs to Spotify songs are added in regular intervals, for example:https://open.spotify.com/track/4sdhaq0Z4KL5oCF5GCgTtt?si=dd9418fa67474b73 I’d like to add these songs to a Spotify playlist automatically every time a new song is added to the Google Sheet. I’m trying to use the following logic:If a new row is added to a Google Sheets spreadsheet, find the song via the URL and then add the song to a specified Spotify playlist. However, the “Find Song” action for Spotify doesn’t seem to work with URLs. Any ideas for a workaround? Best,Jan-Sebastian

3
B
2 years ago
C
C123New
asked in Code & Webhooks
Webhook POST embed to Discord not including all information for the request

I have created a custom request to POST embedded messages to Discord, as per the below:Webhook is setup and working now after using Headers: Content-Type application/json to remove the bad request errorBut the message in discord only displays at the content line - can anyone help

4
C
2 years ago
dennymah
dennymahBeginner
asked in How Do I
Converting a Google Doc File to Mircosoft Word

Hi, I have a simple question. Is there a way for me to convert a generated google doc into microsoft word? Currently, I have a zap where it will generate a google doc and I have to manually click into the google document and click download - save as - docx (microsoft word) format. Is there a way I can eliminate this manual step and have zapier automatically do a conversion from google doc to microsoft word?

4
john4455
1 year ago
L
LochBeginner
asked in How Do I
Adding dynamic formulas to a Google Sheet cell

I am transferring data from one application to a Google Sheet that I’m preparing for an automated dashboard.The first 7 fields being transferred are raw data.  The remaining fields are calculations that in the past I did manually in Excel, using excel functions, such as right, Left, Vlookup, and Year.My first thought was to copy the formulas as they are shown in excel into the appropriate fields in Zapier, so that when a new row of data was created, the formulas would also be created.  The problem is that the cell references do not update to the new row reference.  It stays on row 2, instead of advancing to the new row.Any suggestions on how to create a formula where the cell reference will change to reflect a new row? 

5
GetUWired
3 years ago
J
jg97Beginner
asked in How Do I
Return multiple default values (100+) where answers are blank in Google Forms (Formatter)

Hi All,  I need to create a Zap for quite a long Google Form. 100 questions in the Google Form are not mandatory and I would like to assign a default value for each when there is a blank answer.  I know I could use the Formatter > Text > Transform > Default Value function, however I want to avoid using multiple steps. My best guess is that this could be possible using Google Sheets.  Anyone have any ideas? Cheers!

2
nicksimard
4 years ago
E
EliCBeginner
asked in How Do I
How to upload specific attachment from Gmail to G Drive

Hi All,  Have some little problem here Right now i manage to have a Zap set up that is working 95% of the time, unfortunately i am having problem with the remaining 5% of the time My Zap is scanning new email that contain attachments and sending it to G Drive before sending it to the cloud printer. Unfortunately,When a .pdf and a .png (in the form of an email signature) gets uploaded to the Drive, Zapier Zip them together and the next process gets halted I dint see a way for me to specifically tell my zap to just upload .pdf files .Is there any work away with it?

8
J
4 years ago
Danvers
DanversZapier Staff
asked in How Do I
"My Zap keeps triggering on the same information!" - how can you create your own deduplication?

The question is in the title: how can you create your own deduplication system/steps into a Zap?But first a quick primer on deduplication!There are two types of Zap trigger with Zaps:"Instant" webhook triggers give us whatever they receive at the time, with zero context. This helps them move quickly.Polling triggers run less often, but save the most recent version of whatever information they received. The next time the Zap checks for new information, it can check against the previous version to see if that info's been sent already, if it hasn't then the Zap will trigger on that information.The list of information that the Zap has already received is called the deduplication list, because we don't want to trigger on items. You can learn more about deduplication in this help doc. Sometimes, (for various reasons) webhooks will send information is the same as previous info, and a Zap will fire twice for the same event.Can you think of any ways to create your own &

7
Danvers
4 years ago
T
TeamUltraBeginner
asked in How Do I
Uploading attendee list to Eventbrite

Hi,Any idea if Zapier supports uploading a list of attendees to a previously created EventBrite event? The format of the source file can be csv or almost anything else. I can find a way to do this in Eventbrite or anywhere else.ThanksDavid.

6
T
3 years ago
C
cb2022Beginner
asked in How Do I
Add OR update row in Google sheets

HiI want to start zapping partial entries from Gravity Forms. The issue is that by definition, partial entries creates multiple entries for a given form. So I’m wondering if Zapier can update a row when it finds the same email, OR add a row if the email field is unique.Thanks

8
C
1 year ago
C
Christian HomiBeginner
asked in How Do I
Extract Text from Email without parsing

Hi, within the text below I want to extract:1. the 5-digit code after the string ‘homi.one ‘, i.e. 123452. the mobile number i.e. +3069xxxxxxxx3. the first name Jane4. the surname DoeThe text is the body_plain of text extracted from Gmail for enquiries from customers.The order of info should remain the sameHow can I do this? I am using the text formatter, and I think I may need to use the extract pattern, or split text, but not sure where to go from there.Any help would be greatly appreciatedI have tried parsing, but I had a LOT of trouble, and the parser was always getting it wrong. Body_plainVisit request for the following listing.# homi.one 43866Suburb (Region)Property 41 m<sup>2</sup> for sale€42,000https://www.site.com/abcI really like this property.Please send me more information.It will be me and my two dogs. Jane Doe+3069xxxxxxxx (All day)abc@defg.hij 

3
jesse
2 years ago
CindyinRI
CindyinRIBeginner
asked in How Do I
WordPress and Zapier FAIL!

Looking for a Hero!!!This has been going on for at LEAST 4 months now.We transitioned our Web Dude with another Web Dude - One would think it would be and SHOULD be the same. Yet, new Host Dude says it's not on his side and Zapier says it's Host Dude and I'm stuck getting up at 3:30am so things are updated on Social Media before 5:00am. (Zapier, they've done ALOT for me so I'm not complaining about them)....Unfortunately, we lost at LEAST 30 Blogs which I had to enter manually - But this is me fussing.The issue is NOW - I CAN connect WordPress to Zapier just fine.But when I Post a New Blog - WordPress tells Zapier you can look, but cannot touch. (For example, Facebook, Google Sheets - I've tried everything but the right solution).I'm getting 401 Authorization Errors Sometimes XML ErrorsThe htpp something file.And checked that we do NOT have reCaptcha on (anywhere)Anyone out there that could lend me a hand? Please?Thanks!😀

18
CindyinRI
4 years ago
J
jithinsanalBeginner
asked in How Do I
Zap is not finding new files uploaded to Google Drive Folder

I just set up a Zap, the purpose being to share the mp4 video, that I upload in the Drive folder to social media accounts.Here, the trigger is 'New File in Folder in Google Drive'.The first time I created the ZAP, there was only one file, which it successfully fetched. Unfortunately, it is not detecting any new files that I am uploading. Every time, I test the trigger, it is showing it found a new file, but it is only showing the old one as a different file.Whenever I try to run the ZAP manually, it is stuck at "LoadingLooking for new items...".This is very urgent for me.I am currently under paid plan and I have raised a support ticket with the support team and till now there is no response from their end.  Do let me know what has gone wrong. Thanks.

15
christina.d
2 years ago
A
AshleighDLCBeginner
asked in How Do I
How does "Update Spreadsheet Row(s)" in Google Sheets work?

I’m confused about this action, which I think is relatively new. It says, “Update one or more rows in a specific spreadsheet (with line item support)”, which sounds great, but then in the set up it requires you to pick ONE row to update.   I have tried entering a range (2-4), which creates an error saying that no data (row) was found that matched. I have tried entering the rows with commas separating (2,3,4), which results in it updating row 234 (I got the same result when I tried entering the rows with spaces separating them). Is there something that I’m missing here? How does this action update multiple rows?

3
Danvers
1 year ago
R
rayvoxNew
asked in Code & Webhooks
Converting JSON into individual items

Hi All,I have some JSON that I’m trying to convert into individual items so that I can use the parts in different ways later down the line in Zapier. The data is formatted as follows: {"Title": "Content","Subtitle": "Content2","Name": "John Smith","Date": 1999,"Description": "Long form text area","Summary": "Long form text area","Percentage": 80%}How can I convert each item into an individual component that I can use in other ways? Ideally to also split the heading from the content (i.e. to also split “Title” from the “Content”.  Any help is appreciated. Thanks.

8
R
1 year ago
L
LemonwavesNew
asked in Troubleshooting
Google - "User-rate limit exceeded"

Hey everyone!I’ve ran into an issue with the connection between Zapier and my Pro email account. I can no longer connect the two and I keep receiving this error message below at every attempt: Oh, foo.Zapier could not connect to your account.The app returned "User-rate limit exceeded. Retry after 2022-02-04T17:21:38.363Z".Does anyone have any tips on how I could resolve this?

6
M
2 years ago
O
OtterbotNew
asked in How Do I
Embedding an image from Google Drive into Gmail email

Hello! I absolutely love your product! Unfortunately I don’t know how to code HTML but am slowly learning.I have read the Embedding images in the body of an email in Gmail thread but was still not able to do it.I am trying to embed an image in my email from my google drive.I have been largely unsuccessful. The furthest I have gotten is either a link to redirect to the image or I get a blank square where the image should be. I have switched the body to be HTML. I thought this code looked right. What am I doing wrong? <iframe src="https://drive.google.com/file/d/1Qo9_1KJ8vByoaAhvcPLhZ8cX4mvbFV2I/preview" width="640" height="480" allow="autoplay"></iframe>

11
Troy Tessalone
3 years ago
D
DCCPBeginner
asked in Troubleshooting
Newly created fields not appearing on Zap

We have created a new field on Salesforce and we’re planning to sync it to Jira. However, we cannot see this new field on the Zap.  Steps Taken:Refreshed browser Duplicated the Zap Logged out and logged in the logins to connect to both Salesforce and Jira Used google incognito to make sure caching is not an issue Made sure the new field is accessible the log-in we are using

7
geo_c
1 year ago
A
aldocakeBeginner
asked in Code & Webhooks
Collect responses from Zapier app integration and pass back to original app

Hi All, I am new to the Zapier world and had a question.   I’m currently using Zapier webhook app to pass data in and trigger a new Zapier integration i am implementing. Through process I started to wonder how it is that I can collect responses from my Zapier integrated app back to original requester. In other words, how to pass back response the app making requests to the webhook.  For context, I am just finishing up the Oauth 2 Authentication proccess, I have added my triggers and currently implementing the ‘API Configuration’ when this question dawned on me. Any feedback is greatly appreciated!

6
A
4 years ago
N
N.MasterBeginner
asked in How Do I
Zap automatically Shuts down daily

Hi everyone! I’m running into the same issue that “apsjamie” has encountered where my zap keeps getting shut off. Its been over the past few days my zap has been shutting down and halting the import process to our CRM that I use.Note I’m using: Webhooks →Twilio → Monday → Email By Zapier → Twilio So i doubt that im breaking any of these apps by myself but the question I do have is if Im being rate limited? And If so is there anyway I can stagger the inputs to be delayed or Queued up?

4
Danvers
4 years ago
fiscalitemtl
fiscalitemtlNew
asked in How Do I
Is it possible to exit a loop and move on to non looped steps?

Hi,I’ve looked into the documentation and older forum questions and I can’t really find anyone talking about this in the specific way I’m looking for.What I want to do is to have looped steps in the middle of my Zap, but I want the loop to end before the end of the whole Zap. Here’s an example of what I mean:Form is filled by client and there’s a field that contains multiple answers split by commas Split the text in that field by comma Start loop For each item in the field, do X For each item in the field, do Y End loop Do something else that has nothing to do with the loopEvery time I create a loop, all the subsequent steps are nested inside the loop automatically. Is there a way to avoid this? I know I could just put anything past step 4 before the loop, but the logic of my Zap makes more sense if I put them after the loop.

1
Troy Tessalone
1 year ago
Terms & Conditions