Skip to main content

Get Help

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

28034 Topics
D
domowiNew
asked in How Do I
Where I can find tax residence certificate from 2023?

Hi, Where I can find tax residence certificate from 2023 ? 

1
SamB
Community Manager
8 months ago
A
Amanda KeechNew
asked in Troubleshooting
Microsoft Excel Update Error: "Argument Invalid/Missing/Wrong Format"

Morning.I have a zap which updates a row in excel.That bit seems to work but i’m getting error message argument is invalid or missing or wrong format for the columns which i want updatingHow can i tell which piece of data is the problem - beta ai can’t help as it’s run successfully once.Also I use a date picker in jotform which doesn’t seem to be offered for me to match to and excel column within zapier-any way i can sort this?Thanks

1
Troy Tessalone
8 months ago
A
abarrell2New
asked in How Do I
How do I create a GPT that adds user's email and responses to a Google Sheets row and triggers email flow?

As Custom GPTs will become public I am wanting to create a GPT that creates a new spreadsheet row on Google Sheets when a user submits their email and provides a response to further questions. ie User starts chat and to proceed they will need to confirm whether they are a subscriber with their email address. They will then submit their email which I would then want to be added to a new Google Sheet row. Once added to a new row I will then setup a Zapier flow to send the user a confirmation email and a code, which they can then input into the GPT to proceed and engage further. Is this possible as I know there is a lot that can be done with AI Actions but just need some further guidance around Google Sheets and being able to have anyone engage with the GPT and be able to subscribe and engage with the GPT.

1
SamB
Community Manager
7 months ago
H
helicopterraveNew
asked in How Do I
How do I keep the DD/MM/YYYY date format when creating Trello cards from Google Sheets?

Hey there, brand new to Zapier and I am trying to get entries from Google Sheets to create cards on Trello.Here is the current flow of my Zap:Trigger: new row in Google Sheets. Date in spreadsheet is DD/MM/YYYY Create card in Trello (this ends up setting the date as MM/DD/YYYY) Date/Time in Formatter (to source the date from the spreadsheet again and to add HH:mm after the DD/MM/YYYY) Update Card in TrelloHere is the format modificationUpdating the Trello cardHowever the date remains as MM/DD/YYYYAm I missing something?

1
Troy Tessalone
8 months ago
T
TerjeNew
asked in How Do I
How do I transfer text from Frame.io comments to Trello cards with timestamps using Zapier?

I want to set up a zap that populates my Trello card with a time stamped comment in frame.io. I have sucessfully connected the apps and the comment label is also brought over. However - I don´t see a way of bringing the text in the comment from frame.io over to Trello.Looking forward to hearing what an expert would do. 

1
Troy Tessalone
8 months ago
M
millerfenceNew
asked in How Do I
How do I integrate Angi Leads (ex-HomeAdvisor Pro) leads into JobNimbus using webhooks?

Pardon me... We're trying out JobNimbus now and wondering if we can get Angi Leads (formerly HomeAdvisor Pro) to feed into JobNimbus. I've attached documentation from Angi Leads that describe how their software can provide info. Are we suppose to use webhooks to catch what Angi Leads provides?  Thanks,Glenn

1
Troy Tessalone
8 months ago
cfalcone01
cfalcone01Beginner
asked in How Do I
How do I push column values in Monday.com to Google Sheets every week?

We keep a monday board to time track work on accounts. I’m trying to figure out how to do the following - any suggetions? Here is how my Monday.com board is configured:“item” = account name“column B” (second column over) is the column summarizing the total time spent on each sub-item for this particular account Every Saturday, I want column B from my Monday Board to populate into the next available (unused) column in my Google Sheet so I can track week over week trends in time spent on accounts.  So far I have the Trigger as “Every Week in Schedule by Zapier” > my next action item I have is “Get Column Values in monday.com” but when I run the test, I get an error. 

1
SamB
Community Manager
7 months ago
paulneocube
paulneocubeNew
asked in Troubleshooting
Newly created Zap is creating a new task before marking it as complete

Hey guys. I am new to Zapier and think it is a very helpful tool. I made a few zaps without any incident but I have created one to mark Google Tasks as complete in Notion when they are marked complete in Google Tasks itself. The other zaps between the two services work as expected. However, when the zap runs, it creates a task of the same name and info before marking that one as complete. I have gone over the config of the zap itself countless times and I cannot figure out where I am going wrong. Can someone possibly shed some light on this for me? I am unsure what information is needed to assist with the solving of this issue but please let me know and I will provide it. Many thanks friends.      

1
Troy Tessalone
8 months ago
N
novitalexNew
asked in How Do I
How do I connect Wave to Rotessa without getting any errors using Zapier?

Hi, Anybody try to connect Wave + Rotessa?Can not to create zap - errors every time…Thank you!

1
Troy Tessalone
8 months ago
A
Alex22New
asked in How Do I
How to send ChatGPT-powered email drafts via Zapier with edit & confirm before sending?

I'm trying to create a zap that creates a reply to emails with chatgpt and then sends them to notion or somewhere, where I can edit it or confirm it right away and it sends the email automatically. I'm can't figure out how to configure the part, where I could confirm it. Any help?

1
Troy Tessalone
8 months ago
R
Ryan GeNew
asked in Troubleshooting
Formatting date from Typeform to Word Document via Zapier and Plumsail - duplicate issue!

Hello there!I am using Zapier to collect Typeform entries, then send them to Plumsail to create a word document, prefilled with user inputs from Typeform.The date format in Typeform is DD/MM/YYYY but I want it to read DD Month YYYY (e.g, 09 January 2024) when it sends to Plumsail.I have followed the tutorial here: https://help.zapier.com/hc/en-us/articles/8496257974029-Modify-date-and-time-formats-in-ZapsHowever, in my final word document output I am getting both the DD/MM/YYYY format, followed immediately by the DD Month YYYY format.How do I get this to only show the new formatted date DD Month YYYY?Many thanks!

1
SamB
Community Manager
7 months ago
I
ikhanNew
asked in How Do I
How do I update the subscription in Recurly with the computed sales tax?

I have set up a Zap to compute sales tax using Taxjar when a new subscription is created in Recurly.How do I update the subscription in Recurly with the computed sales tax?

1
Troy Tessalone
7 months ago
M
MilenaNew
asked in Troubleshooting
Failed to create a subscriber in Mailchimp

Hi I want to set up the zap, that adds a subsriber into a group in mailchimp, when a new row is added. In every new row there’s a new e-mail, that needs to be transfered to mailchimp. I have set up the zap: Add subscriber to tag in mailchimp. Connected all my accounts and my google sheetin 2. Add subscriber to tag in mailchimp under action, I have to put in the subscriber email. Here I can only choose the latets email from the latest row in my google sheet. I need it to take a new email every time a new row is added. Then I tired to take the field information from step 1. New spreadsheet row in google sheets. But then I get the error: Failed to create a subscriber in Mailchimp What to do?  

1
Troy Tessalone
7 months ago
X
XenomerseNew
asked in How Do I
How do I integrate the platform with Mekari Talenta and Xero?

I want this platform can integrate with mekari talenta and xero how can i do

1
Troy Tessalone
7 months ago
3
360 SuítesNew
asked in How Do I
How do I configure Zapier to read cards in earlier stages of my Pipefy process, not just those in the final stages?

Is there a possibility of making Zapier able to read the other cards in my pipefy process? It can only read cards that are already in the final stages.

1
Troy Tessalone
7 months ago
M
mollzmpBeginner
asked in Troubleshooting
Productboard webhook throwing “No credentials found for given 'iss' (HTTP Status Code: 401)” error

This post was split from the topic: Product board to slack feed not providing complete information despite delay It doesn’t seem to work for me. I keep getting the following error: Failed to create a request in Webhooks by ZapierNo credentials found for given 'iss' (HTTP Status Code: 401)

1
SamB
Community Manager
7 months ago
C
chrspurserBeginner
asked in Troubleshooting
A False payment failure and forced upgrade from legacy plan

I’ve been a zapier TEAMS plan user since the plan was invented. Many years.In December, Zapier charged me $3351 to renew my teams plan that I have been paying $1375 for every year, on auto-renew.When I look at my invoices, I find a “failed payment” for the teams plan of $1375 and immediately after on the same day, at the same time with the same card on file, a successful charge of $3351. Clearly this failure to process had nothing to do with me, and I didn’t authorize any upgrade to my plan. I was also promised the team pricing forever as long as my account was active. I am hoping this was a fluke and that there wasn’t something engineered to cause this to happen “accidentally” in an attempt to take the legacy plan away from us and blame us for the mistake. Zapier has always been more honorable than that in the past, so I’m going to assume they’ll fix it unless I hear other words.Has anyone else had this pretty fishy thing happen to them?

1
ken.a
7 months ago
H
HarvieNew
asked in How Do I
How do I configure ChatGPT 4 to email analysis or insert it into a Google Docs formatted according to the template?

Hello, I am trying to make an automation that initiates when a Google Form is completed. This Zap should automatically convert the form responses into a CSV file. Following this, a new ChatGPT-4 thread should be generated, where this CSV file is uploaded along with a specific prompt for analysis.  Subsequently, I would like the analysis provided by ChatGPT-4 to be either emailed directly to me or, preferably, inserted into a Google Document. This document should be formatted according to a predefined template which ChatGPT-4 can refer to for structuring the response appropriately.I really don't know if it is possible... any help would be appreciated!

1
SamB
Community Manager
7 months ago
D
Dumpster ManNew
asked in How Do I
How do I pull custom fields from Constant Contact into Zapier for Salesforce record creation?

I’m trying to pull custom fields from constant contact into Zapier so I can pass the values into Salesforce for record creation.

1
Troy Tessalone
7 months ago
R
raghavbajoria123Beginner
asked in Troubleshooting
Email Reader not reading attachments

I made a email parser that takes in incoming emails from my inbox and runs instructions on the attachments from it. When I test this from my own email it works fine. But when a customer sends an email, it does not read the pdf that they send at all. Instead, a default “image001.png” is sent to my pdf reader function built in chatgpt and it gives the incorrect response. In fact, my pdf is even included in the data out for the trigger. I have attached the images for the zap run and how I extract the pdf from the email below.P10008502 is the name of the pdf and it is not even there for some reason. ^ Is the zap run. It should have worked fine but it didn't  If I go to my zap, it shows the pdf is supposed to go to chatgpt. But it does not. Please help me with this

1
ken.a
7 months ago
G
GreatStudioNew
asked in How Do I
How do I invite people to a new Trello board through share URL?

 Following this topic above ^ Is there now a feature in Zapier that can automatically add users as board members, or maybe send them an invite? Any workarounds or solutions would be a huge help, as I'd prefer to avoid doing it manually. Thanks! 

1
Troy Tessalone
7 months ago
C
collintheshocNew
asked in How Do I
How to convert Square Pickup orders to shipment automatically with Zapier?

Hello Zapier Community,I am currently taking self-serve orders through a Square 3rd party app called Kioskbuddy. The orders can only be placed as PICKUP fulfillment type. I can create a Zap Square to Square that creates an entirely new SHIPMENT fulfillment type order with the given parameters from the first PICKUP order, but then I’m left with 2 orders. Ideally I’d be able to just update the order automatically with the fulfillment type changing from PICKUP to SHIPMENT and use data received in the original PICKUP order to include in the shipping address field. Again I have figured out how to create an entirely new SHIPMENT order automatically from the original PICKUP order, but can not figure out how to just update the existing order automatically. Any help is much appreciated!Kind Regards,Collin

1
Troy Tessalone
7 months ago
L
Lucinho BarretoNew
asked in How Do I
How can I translate the available templates in WhatsApp Notification to another language?

This post was split from topic:  I'm experiencing the same issue while trying to connect Mailchimp with WhatsApp, but the provided solution above didn't resolve it.Is it possible to translate the available templates?I'm currently using a custom template. Could this be the cause of the error?"

1
ken.a
7 months ago
B
BenjiwindBeginner
posted in How Do I
How do I setup ChatGPT to auto-fill new topics in a Notion database on Zapier?

Hello everyone, I'm just starting out on Zapier and I'm already aiming for my first automation. My context is simple. I have a notion database, I want that as soon as I create a new topic, my prompt generates the answer to this topic and then fills my notion database automatically. I've got everything set up, but when it comes to setting up chat gpt in my notion database, I don't know what to put. I'm a bit lost...I'd love your help! :) 

1
SamB
Community Manager
7 months ago
A
aleem.ansariNew
asked in How Do I
How do I post photos on my Facebook Page that are published after 7 days?

I want to post photos on my facebook page that are published after 7 days. I want my zap to send the photo either as a scheduled post OR as a draft in my Meta Business Suite. Any ideas how this can be done?

1
ken.a
7 months ago
Terms & Conditions