Skip to main content

Get Help

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

28737 Topics
berprado
berpradoNew
asked in Troubleshooting
ID value from MySQL doesn't match the row value from Google Sheets.

Hi, can anyone give me a hint on this issue. my trigger: NEW OR UPDATED ROW IN MYSQLmy action: UPDATE SPREADSHEET ROW(S) IN GOOGLE SHEETSmy zap: UPDTAES THE ROW OBTAINED FROM THE TRIGGER  BUT THE UPDATE TAKES PLACE ONE ROW BELOW. I mean.. placing the data on row (n) rather than placing it on row (n+1) See screenshotsAs you can see… id 1 is pointing to row 2. I need id 1 to match row 1. My first row on the worksheet is a header row and it was formated according to zapiers advice.There is a video explaining How to set up your Google spreadsheet to work with Zapier. My trigger gets this result after testing: Everything is fine except that row has to be 153 NOT 152 because id 152 points to row 153.The result i get with id 152, row 152 and COL$A 152 is this: bye bye id 151  hello double id152 😭If there was no header row everything would be smooth but i need the header row.Where is my mistake?any hint?Thanks in advance

3
christina.d
1 year ago
ps-zaps
ps-zapsNew
asked in Troubleshooting
Sub Zap error: The app returned "Seen this checksum already"

Hello there 👋Overview: I built multiple zapier automations and use sub-zaps to structure different parts of a big process better and pass information between the zaps.Details: I only use the sends and starts of sub-zaps and don’t need to return any values to the inital zaps. So as I said: it’s just for a better structure within my process. Since it’s required to return values from a sub-zap to an initial zap and I don’t want to make use of this, I use the same text string for every successful run (“success”).Error: The initial zap tells me “The app returned "Seen this checksum already"”. Makes sense since I always send the same value. Question: Can I use sub-zaps without sending information back to the initial zap?Alternative solution: is it enough to just send the current timestamp back so that the checksum varies for each run? Thanks in advance and best regardsPhilipp

1
Troy Tessalone
1 year ago
Abd
AbdNew
asked in Troubleshooting
Tidio error, Zap could not be turned on: The app returned "node_uuid_invalid_uuid"

Help fixing the error in the attached screenshot’s welcome. Thanks.

3
Brem
1 year ago
FunctionalDX
FunctionalDXBeginner
asked in How Do I
How do I add new row in Google Sheets that includes a payment method when theres a new payment in Circle?

We are launching a course in the Circle community platform There will be three payment methods. Depending on which payment method people use, I need to tag them in Mailerlite.There’s no direct way to do this so… I have set up a Zap that places the user email and their Circle tag (which depends on the payment they used) into a Google Sheet adding a new row each timeThat is tested and works. So each time a member of the Circle community makes a payment, a new row is created in the Google sheet along with a tag that indicates the type of payment made.What I can’t figure out is how to do the next step. ie take the user email and the tag from the Google sheet and add them to MailerLite so the contact is placed in a specific Group based on the tag in the Google sheet. Any thoughts gratefully accepted. 

2
FunctionalDX
1 year ago
NFergis
NFergisNew
asked in How Do I
Auto Add Contact to Deal in Hubspot

Hello, Any Updates from Zapier on the Assignment new Deal Trigger ability to auto Add a Contact to the Deal in HubSpot? Thank you.

2
ken.a
1 year ago
J
JacobGBeginner
asked in How Do I
How do I automate multi-step email workflows using Gravity Forms, Gmail, and Wordpress?

Hello! Thanks in advance for any help you can provide. The steps I am looking to perform would look like this.Agent fills out form (gravity forms) with customers information (name, email, phone, subject) Email is sent to client with a paragraph of information and a link below to request approval Once link is clicked an email is sent to another agent with the client information.Anybody know the best tools to do this? We use the services below:Email: Gmail / GsuiteForms: Gravity FormsWebsite: Wordpress

3
Troy Tessalone
1 year ago
asilver
asilverBeginner
asked in Troubleshooting
Hubspot - Company has multiple contacts and each contact has owner, Error

My Zap is working as followed - Find Company in HubspotFind associationsFind ContactsFind Owner of contacts My problem is that sometimes a company will have multiple contacts and those contacts can have the same or multiple contact owners. When I pass the record IDs to find contacts I'm getting an error. I believe it's because it's searching with multiple record ID’s at once. ie (1234567, 987654). I thought I could use looping but that also was giving me an error.  How can I search one at a time? 

3
Troy Tessalone
1 year ago
KJ4301
KJ4301New
asked in How Do I
Quickbooks online and thryv integrations

The specific question I was trying to get clarity on is related to the fields in which your system is pulling in from QBO. Specifically, as part of our desired CRM workflow, we would want to automatically follow up on un-approved estimates in QBO after X of days to the specific person tied to the estimate not necessarily the customer record, can Thryv pull from the Estimate record itself and not the Customer record?

6
KJ4301
1 year ago
S
shushitxBeginner
asked in Troubleshooting
Issue with adjusting UTC timestamp from Slack post

I want to add 9 hours to the timestamp that zapier is reading from slack post because it is transferring in UTC.I tried Ts Time+9h, Ts Time+ZZ09:00 but does not work. 

1
ken.a
1 year ago
AnnaTyrie
AnnaTyrieBeginner
asked in How Do I
Is there a way to set a trigger to create a Google Doc after publishing a Descript transcript as a weblink?

I have a zap the that creates a Google doc of the latest Descript transcripts.  The problem is the Trigger is “Transcript is ready” which is the initial automatic transcript Descript creates before manual correction.  Is there a way to set the trigger to create the Google Doc after I publish the Descript transcript as a weblink? Thanks in advance.

6
Troy Tessalone
1 year ago
Spirit Mamas
Spirit MamasNew
asked in How Do I
How do I redirect quiz takers to specific email funnels in Flodesk based on their results using Interact?

Hey Dears!  I’m in the process of building out my first quiz nurture funnel using Interact for the Quiz and Flodesk for the nurture sequence. In the quiz there are 5 results which is reflected by 5 email funnels in Flodesk. I am having trouble figuring out how to connect the two platforms and redirect people to the adequate quiz funnel based on their results. (so each person receives a personalized email based on their quiz results) If you have any advice or suggestion I would so appreciate it! 

2
Spirit Mamas
1 year ago
pauld-tru
pauld-truBeginner
asked in How Do I
PandaDoc / Hubspot / Teamwork - Pulling in a completed PandaDoc to Teamwork

I have a zap setup to create a project in Teamwork whenever a deal in HubSpot is won. Works just great!I need to add another component.We use PandaDoc to get contracts signed and leverage the native integration between HubSpot & PandaDoc to do that. Again, works great!What I need to do is to is grab a PDF copy of the completed PandaDoc associated with the HubSpot deal and upload the file to the Teamwork project that is created earlier in the zap. Screenshot shows the current Zap configuration. I would envision there needs to be either some sort of additional action before the Notify via email step or maybe some sort of sub-zap somewhere? Thanks in advance for any assistance! 

3
Brem
1 year ago
NeedHelpinCO
NeedHelpinCONew
asked in Troubleshooting
Clio error: Required field "Subscriber Email" (email) is missing.

I have been unable to get Zapier to work with CLIO/Mailchimp on a Free account. Zapier wants me to upgrade for additional support - but why would I pay for an annual subscription on a product I cannot get to work in the first instance?Does the Mailchimp “add subscriber” integration only work on a paid account?

3
christina.d
1 year ago
CharaHarris
CharaHarrisNew
asked in How Do I
How do I do a line break in a field type?

Hello, I am trying to format the field type in an email.Zapier puts multiple items on one line like this: (V4081908787,V4081908801,V4081908930) X 1,1,1I need it to look like this: (V4081908787) X 1 (V4081908801) X 1 (V4081908930) X 1How can I change the format? Thanks any help you can provide.– Chara Harris

1
christina.d
1 year ago
Philosophers4Sustainability
Philosophers4SustainabilityNew
asked in How Do I
How do I create a MailerLite group when a specific Google Forms answer is selected?

Hi there, I’m a relative beginner to using Zapier to interface Google Forms and MailerLite. We use both to keep track of the members in our organization. Our members fill out a Google Form that has a few questions, with multiple choice answers to those questions. I’d like to be able to create a group in MailerLite for a specific response to a particular question.  Is there a way to use a specific multiple choice answer on a Google Form (as in answer A, but not answer B or C) as a trigger in a Zap? If so, what are the steps I need to take? Attached is a screenshot of what I’ve been able to do so far, which is use a particular question as a trigger, but that triggers regardless of what the selected answer was. Is there a way to refine that further by specific answer? I can use the accompanying spreadsheet to our Google Form if need be, but would still like to refine by specific answer, rather than just that they answered the question. Thanks so much!

1
SamB
Community Manager
1 year ago
senaschberger
senaschbergerBeginner
asked in How Do I
Is it possible to create a individual pdf with Typeform?

Hi Zapier Community,  I have a root cause check for digestive problems in typeform.Is it possible to make this?I have questions for:Do you have mental problems? Do you have digestive problems?Do you have problems with your teeth?…. All illness begin in the gut. Because of this I have other questions :).I have texts for why the gut and mental problems and teeth problems are connected. Is it possible, when someone says in the form yes to “I have mental and digestive problems” that in the individual document are automaticly the text from mental and digestive problems will be added? After this I want to send it out automaticly with my email marketing tool called “KlickTipp”.  I am happy for every answer :). I really wonder if this all would be possible.nice regardssebastian

3
ken.a
1 year ago
moliver3
moliver3New
asked in Troubleshooting
How to pull an email address from Facebook Lead form through to Mailchimp

I can’t seem to find the dynamic value to pull in an email address from a Facebook lead form.  There doesn’t seem to be any value available for me to pull in - and when I type manually ‘EMAIL’ or something like that it doesn’t recognise it.  

5
Brem
1 year ago
Melinda Curtis
Melinda CurtisBeginner
asked in Troubleshooting
Zap won't deliver emails (integration of Squarespace to Google Sheets to new MailerLite)

Hi,I created an integration of a newsletter signup form on squarespace, which collects data into a google form, and then the zap is supposed to transfer the confirmed email to a group in mailerlite. Everything works great. The emails show up in zap after confirmation but it has been over 24 hours and it doesn’t show up in the group on mailerlite. I’m sure this is because I’m new and this is free. I’ve now tested it with all four of my emails. I read somewhere on the community that it won’t work for repeat emails. Help!

8
Charie
1 year ago
C
Clickfunnel Set up TriggerNew
asked in Troubleshooting
Monday.com error: The app returned “User unauthorized to perform action”

Hi Team, We have an active zap for FB to Monday.com but since yesterday the zap is getting error as “User unauthorized to perform action” and all the new items stopped due to this. We haven't changed anything in the Monday user level. Can anyone please suggest or help what could be causing it? I'm sharing some of the screenshot below:   

1
SamB
Community Manager
1 year ago
I
InikaBeginner
asked in Troubleshooting
How to update Google Sheets with Stripe subscription status using a scheduled transfer?

I have a zap connecting Stripe and Google Sheets. A new row is added to Sheets every time a new subscription is created. I want the google sheet to be updated once everyday with the Status of the subscription so it captures cancellations. Status is a seperate column in the sheet. I thought of setting up a scheduled transfer between Stripe and Google Sheets. It would need to lookup the subscription id (Column 1) in google sheets in the Stripe subscription database and then update the status. Am not sure how to accomplish this. Any help is appreciated!

5
ken.a
1 year ago
lint631
lint631New
asked in Troubleshooting
Can't find a new clients page for a Facebook lead ad

I know this was a problem a month ago but I can’t find 2 new clients pages in my FB lead ad zap. Anyone having this issue? All permissions are good and we reset the Lead permissions in business manager. Still not working. 

3
Brem
1 year ago
Tico.Social
Tico.SocialBeginner
asked in Troubleshooting
Unable to post RSS feed articles to Brilliant Directories - Failing test and encountering error messages.

I am trying to take a valid RSS Feed and post to articles in Brilliant Directories. I did the dev key in BD, it pulls a record from the RSS feed but never passes a test to enable.  Various error messages. Frankly, I don’t think it works.

3
ken.a
1 year ago
Flowers
FlowersBeginner
asked in Troubleshooting
Dialpad to Pipe Drive Double Entry

This 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. Screenshots: Result:Anyway to prevent double entry please help. 

4
Troy Tessalone
1 year ago
K
KrystalxSxPBBeginner
asked in How Do I
Is it possible to have a yes/no response on whether a survey monkey had a file uploaded?

We have a survey monkey response sheet that has the option to add a file when needed. Not all of our participants need to upload a file, and I know that there wasn’t (last I looked) a way to import uploads from the surveys, but is there a way to get a “file upload is true/false?” We have a parser that brings in all the other data and I typically don’t need to check the survey now except to export the data every so often, and grab those uploads. If I knew which surveys to check for uploads, it would save a lot of time!

3
Brem
1 year ago
Bitam
BitamBeginner
asked in How Do I
Change the "join_url" in Zoom Webinar Zap

Hello,I have created a Zap between Facebook Lead Ads and Zoom Webinar. In my Zoom event, I have multiple registration links for the same event. I want to change the default registration link that Zap sets up for me. It would involve changing the "join_url" link for the "Create Webinar Registrant in Zoom" action.

3
Troy Tessalone
1 year ago
Terms & Conditions