Skip to main content

Get Help

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

28575 Topics
K
kemarshallNew
asked in How Do I
How do I pass information to Stripe from Squarespace?

Currently, when customers purchase products from my Squarespace site, the only information that is passed on in the description field in Stripe is their email address.  Is there a way to pass information about the purchase itself (i.e. what product was ordered) to Stripe using Zapier?  My accountant wants to know!

3
Troy Tessalone
6 months ago
M
Mosto14New
asked in Troubleshooting
Issue with the Zap changing the date format when connecting Excel to Google Calendar.

Good afternoon, I have a problem that Zapier has been giving me recently. I try to connect my excel sheet with my google calendar but the date that excel gives me is transformed by zapier to another format, I have tried to change the format using Zapier's Beta AI but there is no way to achieve a successful result. Could anyone tell me how to solve this? I am sending you screenshots about a specific case, the initial date is in March and it ends up changing to September.Greetings! 

1
Troy Tessalone
6 months ago
A
Admin PipedriveNew
asked in Troubleshooting
Failed to create a lead in Pipedrive - provided dataset is not valid Custom field validation failed. Error: Expected 'number' as value of singleOption field. ApiKey: b6ece909065711a8ef55ac3a5ca806ab0a76d739

I don't understand why I get this error:"The provided dataset is invalid Error in the validation of the custom field. Error: 'number' was expected as the value of the singleOption field. ApiKey: b6ece909065711a8ef55ac3a5ca806ab0a76d739"

3
Troy Tessalone
6 months ago
C
charelleBeginner
asked in How Do I
Is it possible to link a contact to a company in ConnectWise after it has been imported from Keap?

Is it's possible to link a contact to a company in ConnectWise after it has been imported from Keap. Unfortunately, using Zapier, I haven't discovered a seamless method for this, and currently, it involves a manual step post-importing both the company and contact.

9
Troy Tessalone
6 months ago
A
ah1810Beginner
asked in Troubleshooting
Cannot map the right fields from an input form to the right fields in Google Sheets

Hi guys! :)Im abit new to Zapier and really hope there is a solution to my problem! I am collecting leads through GoToWebinar with various fields where people fill out “First name” “Last name” “Email” “Organization” “Country” “State” etc etc, however I encounter problems when I want to collect that in Google Sheets, and (I hope, crossing fingers) theres a solution to the problem. The various inputs from Gotowebinar is being put into the “First name”-column A3 in Google sheets, where I want it to be spread out to different columns such as “Last Name”-B3, “Organization”-C3, “Email”-E3 etc, so not all information is placed in the “First name” column.  My intention would be that it would create a new row everytime a person signs up through the form, and then the fields very filled out accordingly, however I cannot seem to find out how to map it properly when setting up the zap, and when testing the trigger puts everything in first name. Help would be much appreciated!Many thanks in advance

7
Troy Tessalone
6 months ago
R
RooferAdminBeginner
asked in Troubleshooting
Failed to create a create DataObject in Spotio

Hello! Anyone knows how to fix it? 

8
Troy Tessalone
6 months ago
Z
zap_user_111Beginner
asked in How Do I
How do I automate copying new folders with CSV files from Google Drive to Amazon S3 using Zapier?

Hello, I’m new to Zapier and trying to figure out how to build a simple workflow:A new folder with x number of CSV files is created in Google Drive; Copy this folder with all contents to Amazon S3.I’m able to create zaps to “listen” for new folders and create these on S3 (empty folders).I’m also able to map zaps to updated files (each file individually) within specified folders to upload these to S3. What I’m not able to do is to combine both steps so they work in a dynamic manner, as folder names will always be different and contents within these folders may differ as well. Hope what I’m trying to achieve makes sense.

5
Troy Tessalone
6 months ago
P
philiip99Beginner
asked in Troubleshooting
Zapier error "The imported event has a conversion_date_time that precedes the click..."

hey everybody,i have taken a look at other posting to this topic, but i have not found the answer. I have offline conversions setup on Google Ads from Hubspot via zapier, but i keep on getting the following error for every conversion action:The imported event has a conversion_date_time that precedes the click. Make sure your conversion_date_time is correct and try again., at conversions[0].conversion_date_timeI have already put in the correct time zone in zapier, but the error keeps on happening.Anyone has an idea how to find a solution?thank you!

5
Troy Tessalone
6 months ago
D
DT_ARBeginner
asked in How Do I
How to configure Zap to send a single email for all new/updated rows in Google Sheets?

Hi All,I currently have a Google Sheet that automatically clears the information within it, and then re-populates with new data on the 1st of each month.Using Zapier I’ve configured it to email me whenever a new row is added or updated which is working but my problem is that it emails me each single row that’s been added/updated in an individual email…How do I configure this so all rows are contained within a singular email?

4
Troy Tessalone
6 months ago
J
JasonNABeginner
asked in Troubleshooting
DotDigital error: Contact data field phone does not exist. Error_Contact_Invalid (status: 400)

I created connection to send FB leads data to DotDigital.All FB leads data comes through correctly, but when I try to select data fields in DotDigital, it shows the error.I can only select last name, first name data fields which I tested without error. When I add phone number, address, postcode, and test, it shows the prompt as below:  Thanks.

3
Troy Tessalone
6 months ago
S
StackdeckBeginner
asked in Troubleshooting
Zaps for new contact creation in Apollo not triggering Slack message or Pipedrive lead creation.

I’ve created 2 very simple Zaps. 1 is if a new contact is created in Apollo send a Slack message and the other one is when a new contact is created create a new lead in Pipedrive. Unfortunately both don’t work. They also do not show up in the history so I think the event is not being triggered at all. 

3
Troy Tessalone
6 months ago
R
RobinK1978New
asked in How Do I
How to access the auth.users table with Zapier?

I'm trying to create a zap with Zapier and connect to a PostgresSQL database (Supabase) with the purpose of copying emailaddress from the auth.users table and copy them to EmailOctopus. I can make a connection to the database, but I only see the public tables and not the auth.users table. It might be a permission thing, but I do not know what I need to change to be able to access the auth.users table. 

1
Troy Tessalone
6 months ago
A
AtriaResortNew
asked in How Do I
Zapier's Certificate for tax residence for 2023. Where to find it?

Hi, could you please guide me on where I can download Zapier's Certificate for tax residence for 2023? We need it for financial purposes in our country. Thank you. 

1
Troy Tessalone
6 months ago
O
OWNITUSERBeginner
asked in How Do I
How do I create a Zap to remove contacts from a Zoom webinar once they are no longer active clients?

Hi! Similarly to how we can build a zap that adds new registrants to a zoom webinar, could we also remove them? I need to create a zap that removes contacts from a recurring webinar once they are no longe active clients. 

5
ken.a
6 months ago
G
GrowwthNew
asked in How Do I
Add a Tag to multiple CRM contact records for all people who signed a PandaDoc Contract

Hi there. Any help with this would be great. I need to add the tag ‘contract signed’ to multiple Contact Records in LeadConnector once everyone has signed a PandaDoc contact. I’ve tried using Panda Doc ‘Document Completed’ and LeadConnector ‘Add/Update Contact’. But the problem with doing it like this is it bundles all the first names, last names and emails all together in the same fields -  So what happens is I get one NEW contact record in LeadConnector with all the information from all signees smushed into that one record, instead of getting each of the signees’ existing records updated with the tag ‘contract signed’   Anyone have any idea how can achieve that, please?  Thank you.  All the best.  Mark. 

4
G
6 months ago
A
Andrea BrunettiBeginner
asked in Code & Webhooks
Receive file in zapier webhook and transform it in attachment

Hi, I need to read a file byte (or a base64 string file) from Zapier webhooks.The file is a property of a json.I need to transform it (or them) in a zapier file field for send it via gmail as attachment.I read a lot of topics or comments in the web but there is not a clear workaround (here an example)How can I create this complex zap?Thank youAndrea

9
A
6 months ago
T
TerriBruceBeginner
asked in How Do I
How to trigger specific email campaign in Mailerlite for check-in status in Eventbrite?

question (tl;dr version): is there a way to auto assign tags to contacts in Mailerlite based on check-in status in Eventbrite (that is, if a contact IS checked-in/marked as attended, assign Tag A to the contact, but if not checked in for the event by end of the event, assign Tag B to the contact)? Our group runs two virtual events per month. We track registration and attendance for these events via EventBrite. We use Mailerlite to send bulk emails/newsletters to our contact/subscriber list. When someone registers for an event on EventBrite, a Zap runs pushing the contact’s name and email address to Mailerlite and subscribing them to our newsletter. After each event, we like to send an email to everyone who registered and showed up to the event a “Thank you for attending today’s session” email with links to the event handout / materials and such.To those that registered but didn’t show up, we send a “we missed you at today’s event” email. Generally, to send those two emails, I manually

3
ken.a
6 months ago
ReevesUnitedWay
ReevesUnitedWayBeginner
asked in Troubleshooting
Unable to file Smartsheet attachments to Google Drive on my Zap.

I am trying to use the “Smartsheet Attachment to Google Drive” zap. I have it set up and it successfully sends text .txt files when I test the zap. However, when I add a file to the actual Smartsheet, nothing happens. From reading the help documentation, it appears that I am stuck at this part. I believe that I want to select “File” from that dropdown menu. But that is not an option. I have tried selecting every other option from the dropdown and it just generates a .txt file as part of the test, but nothing at all when I actually attach something to a row in the Smartsheet.Some searching in common problems with Smartsheet on the Zapier help tells me:“I can't select my Smartsheet attachments or discussions columns.There isn't currently a way to match file attachments or discussions for Smartsheet Triggers or Actions.”Basically, what I am trying to figure out is:Does the “Smartsheet Attachment to Google Drive” actually work? Or is it not possible at all? If it does work, is there someon

20
ken.a
6 months ago
P
Pfm23Beginner
asked in Troubleshooting
Can’t reset password!

The form to reset my Zapier password is not working. It says my password reset email was sent (see screenshot) but no email is ever actually delivered from Zapier. I’ve tried several times for two days now with no luck — each time the same thing happens. I’ve checked every single folder in my email account, including spam, and even searched my entire email account for “Zapier.” The password reset emails are simply not being sent from Zapier. I’ve yet to hear back from Zapier support. There are urgent updates I need to make to a few zaps, updates that could land me in legal trouble if this login issue isn’t resolved quickly. But until then I’m stuck in login limbo, at the mercy of the Zapier support team.  If you have any insight on how to resolve this issue it would be greatly appreciated!  

9
ken.a
6 months ago
P
purpose-collectiveBeginner
asked in Troubleshooting
Mailchimp error: "Trigger partner failure: Resource Not Found"

I have a simple two-step zap that has been running successfully for over a year. In the last 48 hours, I’ve received over 30 “possible error” messages for this zap. I actually have two very similar zaps, and it’s happening for both of them.Each message is the same: “Trigger partner failure: Resource Not Found - The requested resource could not be found.”Strangely, when I look at the zap history, there’s nothing for this zap there. No errors. No successful runs, either -- it hasn’t been firing at all (which is expected). Yet the error messages keep coming.When I edit the zap and try to pull in more records for the test phase, I get a similar error message: “Unable to pull subscribers. Please reload the page. If the issue persists, troubleshoot error or contact Support. Error code: Error while retrieving: Resource Not Found - The requested resource could not be found.”The trigger is “New Subscriber in Segment or Tag in Mailchimp.” I tested the Mailchimp connection itself, and it’s workin

5
ken.a
6 months ago
S
steve01863New
posted in How Do I
How can I set up a follow-up email with a Zoom link after a Fullslate booking using Zapier?

I have a client that uses “Fullslate” for calendar booking and CRM.  “Fullslate” does not offer Zoom integration when scheduling. My client is looking to have a follow-up email appoinment with zoom link sent after a Fullslate zoom meeting is scheduled. Thank you.  

1
ken.a
6 months ago
Z
zap4dummiesNew
asked in How Do I
How do I create a Zap for posting Google Forms entries to TikTok and Instagram using Buffer?

This is what I want to achieve. Create a Zapier workflow that does the following:Takes Google Forms entry with the following data (Video Title, Video Description, Video Tags, Video File Upload from Google Drive) Submits the data to Buffer and schedules to post to Tik Tok, Instragram Reels, and Instagram StoriesThe co pilot AI tool suggested that this be my Zap flow steps: I have tried this method but it still wont allow the right formatting or for Buffer to get the file.Can someone please see if this type of flow is even workable and show me how. I am willing to pay! 

1
Troy Tessalone
6 months ago
T
TaraLuckeNew
asked in How Do I
Save as an existing Excel spreadsheet as a new document

Hi, how do I create a zap so that when File A (a zoom meeting attendance report) is saved to a Onedrive folder, File B (my template file - a Microsoft Excel file) is duplicated/saved as a new Microsoft Excel file with the date in the file name? This is part of a larger zap I want to create for a weekly task where:File A is savd to a Onedrive folder Which triggers my template excel document (File B) to be saved as a new document (File C) Particular data is then extracted from File A and added to File CI have worked out how to do this if I want to update File B witih the data from File A, but I want to keep File B as a template because each week we have to submit File C as a report and I don’t want the data for each week to be overriden each time the zap is run.

3
Troy Tessalone
6 months ago
S
svena69New
asked in Troubleshooting
Issue with certain Notion file field as input

Hi, For some reason when I try to use a “file” field in the input of an action as content the zap won’t work and give an error stating: “Failed to create a database item in Notion - Cannot read properties of undefined (reading 'tokens')”Input in the action under “content” is: “[]()” which resembles a file input field in Notion.Everything else works, except when you put this in your content. Quite annoying at this point cause I need the file input fields to be there and haven’t found a way around it other than not having Notion insert a file input field at all.Would anyone know how to get around this? 

1
Troy Tessalone
6 months ago
D
DClNew
asked in How Do I
How do I initially populate a table with all records from a service and then keep it updated with Zapier?

I have three services with data that I want to correlate.  There are keyfields that will be used to link all records.  The plan is to create a table for each service, then populate all records using a query.  With the first service, I am unable to find an option to select all records, I am only allowed to use the “add record trigger”.  How can I initially populate the table with all records (about 1800) and then use the trigger to keep the table updated? 

1
Troy Tessalone
6 months ago
Terms & Conditions