Skip to main content

Get Help

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

28308 Topics
C
catccNew
asked in How Do I
How can I extract a single, specific line from an email body?

I am trying to set up a zap to pull some information from the body of emails it receives. This particular kind of alert email follows a fairly static structure, and one of the pieces of information I want is always the 6th line of the email.Right now I have a Formatter step which uses the Split Text transform against the email body, with [:newline:] as the separator. I have it set to return All as Line Items and when I test it, it properly returns Output with all of the lines of the emails split into separate numbered line entries.When I try to use the Output of this step in a Path or as the input to another Formatter step, I only get the ability to select the output of the command as a whole. I would like to extract the 6th line item from this output. There are no other easy delimiters or patterns I can use to Split against. When I try to use some of the other Formatter options available I only have the ability to select the first, second, second last and last entries out of the list.

2
Troy Tessalone
3 months ago
K
Klinkloans FundNew
asked in Troubleshooting
Zap for DocuSign signature envelope missing data from Gravity Form

I recently created a Zap to send an “Signature Envelope” from docusign. The data is being pulled from a gravity form, and is properly matched up to the template fields from Docusign. The “Data In” section is correct but the “Data out” is left blank - see screen shots below. When the signature envelope is sent it is blank. Any ideas on how to fix this? 

1
Troy Tessalone
3 months ago
I
itheasuppNew
asked in How Do I
Send email with html body and svg

Hello, I need to send emails with the body type html and an svg inside the body, for some reason the emails arrive without the svg element. Thanks in advance.

3
Troy Tessalone
3 months ago
G
gabe1234567Beginner
asked in How Do I
How do I mirror Zoom Team Chat messages to ClickUp for centralized communication?

I want to make it so when I receive a message from someone in my zoom team chat, that message is sent as chat in clickup as well. The message should specify who and where it's coming from. The ultimate goal would be for all conversations from zoom to show up in clickup as well so I would want my responses in zoom to be seen in clickup as well. I want clickup to be the central hub for storing communication while still being able to use the zoom platform.

5
Troy Tessalone
3 months ago
R
Reluctant CanuckNew
asked in Troubleshooting
Can't get the Paypal "item name" Filter working (for a subscription)

Hey all,I’ve created a Zap between Paypal & Google Sheets, the goal is to add customer data to a sheet when there’s a successful sale of a certain product, in this case a recurring membership.I’ve done this many times in the past for one-time payments (for digital products, software, etc) with no issues in other existing Zaps.But in this case, the Zapier filter isn’t able to "see” the transactions for the recurring product when we run test sales, etc.For the filter rules, I’ve selected every variant of the “Item name” field, as well as the “Transaction subject” field, and obviously set the conditions to “OR”, so it only needs to find a single instance of the product name across all those fields.It’s still not firing.Is there a special way to do this for paypal subscription plans?Are subscriptions not part of the “Successful Sale” trigger for Paypal?Or is this maybe a problem on the paypal side of the equation.Just wondering what I’m missing here…Thanks~ CanuckPS. And yes the Zapier

7
Troy Tessalone
3 months ago
R
Robo2030New
asked in Code & Webhooks
Get more than 500 rows

How can I get 3000 rows at one time? I setup the Lookup Spreadsheet Rows (output as Line Items) in Google Sheets but it’s limited to 500 rows? Then I thought about creating another zap and starting from the bottom of data but that still only gets me to 1000 rows. I finally attempted to write a google script and add a webhook but I have no clue how to do it on a step-by-step basis. I’m new to this so it’s a lot to digest. Help!

12
Troy Tessalone
3 months ago
C
ChrisAVCBeginner
asked in Troubleshooting
Move File In Dropbox Formatting Error - 'Malformed_Path"

I have a Gravity Form connected to Zapier which allows a user to submit images. These images are hooked in to upload to Dropbox. I am trying to create a folder with the user’s email, and have the images moved from the original upload location to the folder with their email address. Part 4 is giving me the following error:  Failed to create a file in Dropboxfrom_lookup/malformed_path/I feel like maybe this has something to do with the File url above….. (not i also tried with no / in ‘Path’ above as wellcan anyone help advise on this? 

4
Troy Tessalone
3 months ago
M
ME12345Beginner
asked in How Do I
How do I clean and format RSS feed content to remove codes and add plain text?

HI. BASICALLY WE ARE EXTRACTING NEWS ARTICLE TO A DIFFERENT WEBSITE USING RSS FEED HOWEVER, WHEN THE CONTENT IS ADDED THERE ARE SOME CODES ADDED IN IT. HOW DO I CLEAN IT OR FORMAT IT PROPERLY SO I CAN JUST ADD PLAIN TEXT TO IT?See sample 

8
Troy Tessalone
3 months ago
JoMiller
JoMillerBeginner
asked in How Do I
Kartra Connection

I really hope that someone can help me! I am trying to create a really simple Zap for one of my clients to add detail to a Google Sheet when a lead fills in a Kartra Optin form. I have requested a Zapier integration in Kartra, which has been approved but, when I create the Zap and go to sign into the Kartra account to link, I am being asked for the API key. My understanding was that simple Zaps do not need an API key…..The Kartra account that my client has does not support API as this would cost her an additional £100 per month which seems a little excessive to collect a few names, and Instagram handles!Am I unable to use Zapier in this way? Has anyone else set this up without APIs? Maybe I’m doing something stupid 🙈

2
JoMiller
3 months ago
H
HenryHBeginner
asked in How Do I
How do I download all PDF attachments from Gmail and upload them to Google Drive seperately (not a zip file)?

Hello Zapier Team,I am new to Zapier and a beginner at AI.Is it possible to create a zap that does the following task?1) Download all attachments from a new labeled email from Gmail (separate PDFs)2) Upload the attached files into a Google Drive folder (not a zip file)3) Hyperlink the attached files from Google Drive into an existing Google Sheet Row with a comma, space, or break between each hyperlinkEvery time I try to download the all of the PDF attachments from Gmail to Google Drive, it becomes a zip file. When I try to download each attachment separately, it says “LazyFile is not JSON serializable”.Is it possible to download all (PDF) attachments from a new labeled email from Gmail to Google Drive in seperate files instead of a zip file?

8
H
3 months ago
B
blutwerteNew
asked in Code & Webhooks
Issue with linking companyname ID in Zoho Begin with pipeline record

Hi everyone,I am in the process of setting up a Zap in Zapier to create a new contact, company and pipeline record in Zoho Begin from a contact form submission via a webhook. While I can successfully link the contact to the company via the companyname ID, I run into a problem when I try to link the pipeline record to the company ID. The problem is that there is no field in Zapier to link the pipeline record to the company. There is only a field to add a contact with a contact ID.Has anyone had any other experience with this issue or know how to resolve it?Any help or suggestions would be greatly appreciated!

1
Troy Tessalone
3 months ago
Bellevuefineart
BellevuefineartBeginner
asked in How Do I
How can I add a user to my account if I have a programmer helping me?

I need to hire a programmer to help resolve some issues I’m having with Zaps. How can I add a user to give them access to my account? 

4
Troy Tessalone
3 months ago
L
Lucrece ABeginner
asked in Troubleshooting
Trouble connecting Squarespace form to Hubspot

Hello, I need some assistance reconfiguring a Zap I created to connect a Squarespace form to Hubspot. When a person submits the form on Squarespace it’s supposed to create a contact in Hubspot. It worked before, but somehow it’s not working now.

5
Troy Tessalone
3 months ago
A
ajay6688New
asked in How Do I
Is it possible to fill values in specific cells of a Google Sheet spreadsheet?

Hi @Danvers Directly coming to the point . In my Trigger i have a google form that is collecting data like First Name , Last Name , Address , Zip Cide , Phone etc . I have a google sheet template in which positions of these values are fixed.  In action i want to copy this sheet and in that copied sheet i want to update the values according to the positions of the cells like First Name should be at <First Name> in the sheet and Zip Code should be at <Zip Code> in the sheet like that only .In end result what i want is every time when i get a google form response i should get a new google sheet with updated values according to their cells places in the sheet .is it possible to do this in Zapier.if it is possible then how ? . please help me .Thanks

2
Troy Tessalone
3 months ago
J
JamesLMartinBeginner
asked in Troubleshooting
Sync from Google Calendar to Zoho Calendar - Time Format is Incorrect

I have a Zap setup to create a Zoho Calendar event anytime a new Google Calendar event is made. The time in Zoho is incorrect. Zoho is dropping the 1 in front of 18:00 and 19:00 and making it 8:00 and 9:00 see below:Both Calendars are on 12 hour timeHere are the run details:Google Calendar: start: dateTime: 2024-02-09T18:00:00-05:00Google Calendar end: dateTime: 2024-02-09T19:00:00-05:00Zoho Calendar: start: 20240209T080000-0500Zoho Calendar end: 20240209T090000-0500

16
SamB
Community Manager
3 months ago
Andy Halliday
Andy HallidayBeginner
asked in Troubleshooting
OpenAI: “Invalid file format” error for mp3

This post was split from the topic: Trigger "new file in folder" doesn't find new uploaded files in GDrive@Troy Tessalone the Trigger seems to reload an older file (help doc says >4 hours old will be skipped) but in the test environment I can find and select the .mp3 file, so I am now moving on to the Transcription of the file using OpenAI Whisper action. BUT even though I only have 2 .mp3 files in the target folder, and have selected that one as in the first screenshot, when I test the action, it returns the error shown below (invalid file type). What?! I hope you can help me with this further roadblock.  

5
SamB
Community Manager
3 months ago
D
DV_AutomationBeginner
asked in Troubleshooting
monday.com "Location Column" empty when updated via Zapier

We have “location column” in Monday.com. When we use zapier to enter new information into that column in this formatStreet Address, City, State, ZipcodeThe field in Monday.com ends up being empty like its being rejected for some reason. Who else dealt with this, do we need to clean up the data first and how?Thank you

5
SamB
Community Manager
3 months ago
A
AdriennNew
asked in How Do I
Integrating Mozello with Mailchimp

Dear Community,I am new to Zapier, and I am here, because I started to use Mailchimp for my webshop. What I had made 4 years ago, and it's a custom webshop powered by Mozello. Unfortunately I can not integrate this website with Mailchimp, it's not yet in their system. Therefore I cannot write emails that has store products in it wich would lead to my website, nor do abandoned carts etc. Is there any way I can do this via Zapier? Side note - Zapier does not has Mozello integrations either. Thank you for your help

2
SamB
Community Manager
3 months ago
S
SeriouslyBlankNew
asked in How Do I
Zap for monitoring the changes in a Google Sheet and updating in a different sheet

Hello, new to zap here. I wanted to create a zap where it monitors a spreadsheet lets say ‘test-1’ with ‘sheet-1’ as sheet name. whenever a user who has access to spreadsheet ‘test-1’ edits a row or makes changes to the spreadsheet, which will be the trigger. I want it to paste the new value of the cell, old value of the cell, who edited it i.e. their email id, the time it was edited at, and the cell edited to another spreadsheet called ‘test-2’ with ‘change log’ as the name.is this possible? I was able to create a similar log sheet using google apps script but it needed the log to be in the same sheet as test-1 which would mean the logs can be viewed by the editors in test-1

2
SamB
Community Manager
3 months ago
A
AnjaliAgarwalNew
asked in How Do I
How do I automatically create Salesforce records from Wix form submissions?

How do I create record in salesforce whenever a wix form is submitted 

2
JammerS
3 months ago
V
vjedlickaBeginner
asked in Troubleshooting
Unable to connect to my Google Sheets

I have a google sheet named “mycustomers”.I cannot connect to it from zapier. I put mycustomers into the “spreadsheet” text box and nothing happens.

3
V
3 months ago
J
JokerrNew
asked in How Do I
How do I add a tag to a Kajabi client and trigger an email with quiz results from Interact integration?

Hello! I’m trying to integrate Interact so that when a quiz is complete it adds a tag to a client in Kajabi which then will trigger an email with the results of the quiz. Is this possible?

2
JammerS
3 months ago
S
Some fun ZapNew
asked in Troubleshooting
Failed to create a record in Salesforce: Could not update the task record with ID Open.

I’m working on a Zap,Call ended In RingCentral > Find Record(phone#) In Salesforce > Find Record(Task) in Salesforce, Update record(Task Status) In Salesforce. The third step finds the record - At the last step, it says that it can’t find: “ID Open” - What am I missing here?

2
JammerS
3 months ago
I
irvBeginner
asked in Troubleshooting
OAuth redirect URL provided by Zapier returns 404 on Zapier

Hi team, I am working on setting up a Zapier integration using the OAuth v2 flow.After the user is successfully logged in on our app then the app redirects the user back to the Zapier OAuth redirect url e.g https://zapier.com/dashboard/auth/oauth/return/XXXCLIAPI/. However when the user is redirected to the mentioned Zapier OAuth redirect url with the authorization code appended, it throws a 404 error when it tries to open the Zapier page. I noticed this does not happen when I sign in and authorize with other apps. I also confirmed the redirect URI is the same on my end and Zapier’s end. Is it possible i am forgetting to include something, or perhaps the URL provided by Zapier has an issue?

3
SamB
Community Manager
3 months ago
A
Alexander LazarevNew
asked in Troubleshooting
Facebook Lead Ads to Google Sheets Zap is missing contact data

Hi,  We have set up a zap for pushing leads from lead ads to a google spreadsheet. Some of the submissions are missing contact data (name, email, phone nr).  There is no coherent reason why this happens as some of the submissions come through flawlessly. We ask for additional questions and those always come through without error.  For now also no coherence between form vs missing info. Same form sometimes pushes through all lead data and sometimes it misses the contact info.  Any idea how we could fix this? We tried setting up the zap 3 times with different accounts and the result is the same.  Thanks!

3
ken.a
3 months ago
Terms & Conditions