Skip to main content

Get Help

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

28077 Topics
omarbortolato
omarbortolatoBeginner
asked in Troubleshooting
Notion not updating existing item rows

This post was split from the topic: date.equals should be defined, instead was `undefined`Hi all here we go again :)Today I made some changes on the Gsheets source file and actually I see a success zap run, but no evidence on the Notion DB :(Below is the screenshot where you can see “Data in” and “Data out” where the status has been change from “closing” to “Sold”.But on Asset DB nothing I see a duplicated row with 2 different previous statuses. See ID QU36. I also changed ID46 but it doesn’t appear on zap runs yet. I also noticed other duplicated raws and it reflects the tests I made yesterday trying changing some value Any help from there? :) Thx folks

1
SamB
Community Manager
1 year ago
A
anatesanStreamBeginner
asked in Troubleshooting
My S3 file uploads are getting truncated!

Frankly,  I am having a host of problems with the S3 zap on the Upload file.   1) There is a omission in the s3 connect dialog that essentially prevents you from creating a S3 connection to the US-East-2 region.  The drop-down does not have this option.  If you had buckets in that region,  it basically means you cannot upload anything using this Zap.   Zapier apparently hasn’t prioritized this fix very high - at least there is no ETA on a fix.    In any case,  I got around this by moving my bucket to us-west-1, a workaround that took me some 3-4 hours of work and is probably infeasible for anybody with a complicated AWS deployment on us-east-2.2) A much more serious and showstopper issue is that the upload zap seems to be randomly chopping up and trunctating the file being uploaded.   This is the file loaded with the zap - Note the size: 89.2 kb  This is the same file that has been uploaded through S3 console.   Note the size is 181 kb.Essentially, thanks to the truncation,  my .docx a

10
A
5 months ago
N
NicoleSANew
asked in How Do I
Google Analytics does not create a measurement

Hello,  I am trying to create a measurement in Google Analytics. My aim is to create a goal in google analytics when a form is submitted on Hubspot. The data is sent successfully however Google Analytics does not display the goal.  Event category and event action fields are filled correctly.    Can you help me with this? 

2
Danvers
4 years ago
J
jpmuofuNew
asked in How Do I
Identifying Paypal Recurring Payments

We are using Zapier to push conversions to Google Analytics, Facebook and Marketo when a successful recurring purchase occurs. However, we only want to send this conversion on the first successful payment, not everytime thereafter. I can’t seem to find a Paypal field that indicates that a successful payment was not initiated manually by the user but automatically by Paypal. Any ideas how this could be accomplished?

1
Liz_Roberts
4 years ago
T
townley-jonesBeginner
asked in Troubleshooting
Unable to create a folder on Microsoft SharePoint, error 404 File not found.

This post was split from the topic: Sharepoint error: We're having trouble loading 'Folder' data. undefined. Error code 404: 404 FILE NOT FOUNDWhat was the solution for this? I also just want to create a folder on sharepoint but Zapier haven’t made it easy at all.

8
ken.a
8 months ago
B
Bruno FrazzoniBeginner
asked in How Do I
Save filtered spreadsheet as PDF

Hello everyone,I’ve been trying to automatically send a filtered list from a spreadsheet using filters from data I collect from Typeform, so any person gets a filtered list from my database according to the needs they report.So long I’ve had no trouble using the data from Typeform and accessing and filtering the spreadsheet, but when i want to send the filtered spreadsheet to the person that asked for it, I don’t know in which format I can do that.I’ve tried to attach the filtered 20-row data to GMail, but it attaches a .txt file for each cell.I’ve also tried to save the filtered spreadsheet as a new file and sending that, but I can’t format it into rows, instead I get only the headers.Also I tried to convert the filtered spreadsheet into a PDF file and then attaching that to the e-mail, with no luck on creating the PDF file.Does anyone know how can I get the result I want?Cheers,

5
Danvers
1 year ago
S
SOYBeginner
asked in Troubleshooting
ActiveCampaign error: The app returned "Invalid value for query parameter contactTag.contact"

Hello, I am trying to use this zap. However getting “Failed to create a contact tag in ActiveCampaignThe app returned "Invalid value for query parameter contactTag.contact"” error. As far as I understand, zap is trying to find the internal ID of a contact from Activecampaign. However, the Google form I am using doesn’t have that field. Users wouldn’t know their AC IDs anyway, if I ask them, they won’t be able to enter it. How can I fix this? Thanks. SOY

5
ken.a
7 months ago
E
eternusBeginner
asked in Code & Webhooks
POST & GET webhook with UserID from Discord trigger

So i need to make a POST and GET requests and the query string is based on message content but i dont understand.. I’d like to post something like !rep + <@userid> So the message in discord would say “!rep + 75869783647561183” and it would send the USERID (75869783647561183) to my website located at http://eternaltesting.xyz/post.php and have ?userid=75869783647561183 attached to it. so overall the post made to my website would look like this http://eternaltesting.xyz/post.php?userid=75869783647561183&p=1&n=0 Is this possible??? it would be amazing if it was!  also please note.. when users say !rep (+) userid its focused on the + so the value &p=1 means its a positive addition.. if the post says !rep - userid then  value &p=0&n=-3 would be applied.  Can anyone help!!!!

2
E
3 years ago
G
GowiemBeginner
asked in Troubleshooting
Notion error: > Expected block type heading_1 in request body

I am getting the following error when using the “Update Database Item in Notion” action:> Expected block type heading_1 in request bodyThis doesn’t make sense and I can’t seem to fix it. Is this a known issue? I don’t see others with this same issue online. 

6
A
1 year ago
C
charlesriverBeginner
asked in How Do I
How do I convert data that comes through via email from CSV into Google Docs table format?

Hello, How do I convert data from csv (that comes through via email) into Google doc table format? I am using “create doc from a template “ feature, however, I am having formatting issues  Step 1: Find File from Gmail (works)Step 2: Converting attachment into cvs using “Utilities” Formatter  (works)I want to create a table (with exact same information in the csv) into a Google doc but coming across formatting challenges (Not working) What Do I Need in a Table of Google Doc (Final Output)Product Name.          QntyProduct 1                    10Product 2                    15Product 3                    20 What I am actually getting post using Formatter  Product Name: Product 1,Product 2,Product 3Qnty: 10,15,20

13
jesse
2 years ago
D
DarkBeginner
asked in How Do I
Facebook Page doesnt show link properly

Hello everyone. I’m having a problem with the Facebook Page. I have connected it to my facebook acc and confirmed all the permissons. However when i try to text in Message Text, it always show “Link: zapier.com” it supposed to be link of my facebook post?  This happens when i try to connect my facebook page to discord. I used Facebook Group connect to Discord it works perfectly but i dont know why Page to discord it becomes like this. Can someone help me how to fix this? Thanks and sorry for my bad English  

5
Danvers
4 years ago
P
PaperGrailNew
asked in How Do I
How to format multiple value fields and perform math? (ActiveCampaign-->Google Sheets)

I’m trying to have ActiveCampaign update Deals or create new rows for new Deals into a Google Sheet. Everything is working great except for some reason, ActiveCampaign spits out dollar amounts in CENTS and not whole dollars which is just...frustrating. I have multiple columns in my Google Sheets that need to be dollar values formatted as currency. I can get my zap to divide by 100 to get the proper dollar value and format it correctly, the thing I’m having trouble with is how to format 3 different columns this way without having to do a math step and a formatting step each time. Is this possible? Here is some sample data with the two columns highlighted that are coming over as cents instead of dollars. What’s the most efficient way to achieve conversion to whole dollars?

3
Troy Tessalone
2 years ago
J
JeanTinkerer
asked in How Do I
Can Markdown be enabled for Notion content?

It looks like Markdown is not parsed in Notion content.It would be really great if it is. Would it be possible to enable it?

1
Troy Tessalone
3 years ago
H
heatherhNew
asked in How Do I
Mighty Networks purchase plans and canceled subscriptions

According to this page - https://faq.mightynetworks.com/hc/en-us/articles/115005753603-Use-Zapier-to-Automate-Tasks-Between-Your-Mighty-Network-and-Other-Apps - it is possible to create a Zap for when a Mighty Networks member purchases or cancels a subscription plan. However, I don't see that option when trying to make a Zap.I'm trying to create subscription plans on Stripe for my courses (because Mighty Networks doesn’t offer the ability to do what I need). Classes start on September 6, but I need to be able to presell now, offer a free 1-week trial, have a specific end date for subscriptions, and prorate when there are only a few weeks left of class.(I will be teaching a total of 14 different classes for 16 weeks each and need to have weekly and monthly subscriptions, as well as 2 payments for the 8 week option and 1 payment for the 16 week option.) Again, from my conversations with Might Networks, my needs are only possible through Stripe itself. I would like to automate all of this

1
Danvers
2 years ago
F
FrancoBeginner
asked in How Do I
How to improve my integration between Google Sheets and Mailchimp

I created my first, non trivial, ZAP connecting Google Spreadsheets with Mailchimp. So far I’m extremely (positively) impressed by this tool. My congratulations to the Zapier team for developing such a powerful yet simple-to-use tool. As a technical person I can be critical of online tools, but for Zapier I really have (and want) to give credit to the tool and to the excellent team that created it.Here my question.I have a list of attributes on my spreadsheet (they come from my eCommerce platform) and I want to update the matching Mailchimp subscribers profile with those attributes in order to use them (with merge tags) to customize the email communications. I added a couple of filter to skip lines from the spreadsheet without a proper email, and to include only subscribers in the next batch of order deliveries. Magically everything works and the attributes move from the spreadsheet to Mailchimp!I only have a couple of questions:When my ZAP tries to update a user that is unsubscribed o

2
Danvers
3 years ago
A
aorisNew
asked in Troubleshooting
How to get MySQL fields updated in Zapier?

Hello,I am working on an integration from Leadfeeder to MySQL and I the Refresh fields button does not work. Any idea on how to resolve that issue? I know that I can delete and redo the task, but that’s simply a waste of time. Any idea? Thanks all! 

8
T
1 year ago
M
mcbeyonceBeginner
asked in How Do I
How do I use Heroku Postgres database as a trigger?

Hi dear Zapier friends, Do you know if it is possible to connect to a Heroku Postgres database?I am trying to find whether there is a firewall or something like that that would make it impossible but couldn’t find the answer out there.Thanks for your help. 

2
M
2 years ago
K
kshookBeginner
asked in How Do I
Creating WordPress Post from Twitter Images

Hello all!  So what I am trying to accomplish is monitoring my Twitter account for new likes & if those likes include an image, it will pull the first image of the tweet and create a WordPress post with that image. I have had success building the zap, mostly. However I am getting an error from some tasks on the WordPress post creation step concerning “Fault (code 404) occurred. Message: Invalid attachment ID.” One thing I have noticed, I’m using the Twitter screen name as the post title and the tasks that are returning an error have screen names with underscores in them. Would this be causing the error? (*UPDATE* Had an error from a name without underscores too now.) Thanks for any help & time! (bonus points if anyone knows how I can pull more than one image from Twitter posts)  

4
Danvers
4 years ago
W
WinstonBeginner
asked in How Do I
Zoom meeting registration to Activecampaign

I am looking to create a Zap that pulls name and email information from a Zoom meeting registration and create a contact and put it to an Activecampaign list. No different than the basic Zap and they have an Evenbrite registrant → AC list. However the Zoom side only allows to pull registration information from a webinar and not a meeting. So is there a way to pull the data from the meeting registration information?

9
shalgrim
3 years ago
P
PaolonBeginner
posted in How Do I
Issue using Google Assistant on iPhone

i have tried the slack integration an an iphone google assistant. just used your integration, dos not work. namely the phone does not trigger the zap. what to do?   I tried to integrate with the app zoom.ai but we do not even start the communication, has someone developed this integration? to me it is only two apps flow , seemed simple but it dos not even start.  is there a specific youtube video demo about using google assistant on iphone?

7
steph.n
4 years ago
I
InsuranceBeauxBeginner
asked in Troubleshooting
Zapier Parser - rejecting email redirects

I’ve been using Zapier Parser to parse a lead email that been redirected from my office 365 account for 10 moths.  Last Wednesday it broke.  I can email directly from my 365 account to the Parser and it works fine.I can forward or redirect and it work.  Any suggestions?  I parse about 60 - 90 emails per month.  

2
S
3 years ago
F
FRTBTTBeginner
asked in How Do I
Create email address from first and last name

I am looking to set up Zap for creating a new user in Okta. The way my company sets up emails is by first initial and last name, so John Doe would be jdoe@company.com. I’ve set the text formatter to break up a first and last name from a single cell into two separate cells. I am not sure how to take the J out of John, any one have ideas??

3
F
2 years ago
S
shaylama_7Beginner
asked in Troubleshooting
Automated email text is getting cut off while setting up action from a form submission

I set up a zap to send an email after a form submission, however when I test it the body of the email keeps cutting off text in the middle of the word.How do I fix this?

8
S
2 years ago
C
commoncauseBeginner
asked in How Do I
Can't create new zap steps, stuck on "To Continue, Finish Required Fields"

This is happening on both existing zaps and new ones -- what’s going on? Anyone experience this before?  

9
C
3 years ago
K
kaychrisaBeginner
asked in Troubleshooting
Google Calendar 'Attendee Emails' variable has no data?

First time using Zapier here. I’m trying to create a Zap that sends a reminder email (via Gmail) to all meeting attendees fifteen minutes before each meeting on a shared Google Calendar. The problem is that that the “attendee emails” variable for the events always comes up with “no data” and thus, won’t send to anybody. I’ve tested everything else, and it works if I add my own email by hand, but nobody else appear on the “to” list.The only thing I could think of is that it’s because I’m using GCalendar’s bookable appointment scheduling feature, and that somehow doesn’t enter attendee’s emails? Any advice would be helpful.

8
K
2 years ago
Terms & Conditions