Skip to main content

Get Help

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

28248 Topics
S
seb delBeginner
asked in How Do I
How to add an export of the airtable file each month to a .csv file that we send by email then automatically as an attachment?

I have seen this topic: https://community.zapier.com/how-do-i-3/how-to-add-daily-csv-export-into-airtable-10997But it doesn't work for me. I'm not sure how to do this, but I'm sure it will work for me, and when I download the file from airtable there are no columns in the file as there are on airtable. Everything is in column A.Can you help me? I am very new to the airtable - zapier world.Sincerely yoursSeb 

4
SamB
Community Manager
1 year ago
M
MGL_DevBeginner
asked in How Do I
Increasing order number in Google Sheets

We have a challenge with our online bookings form which integrates with Zapier and we hope the community can help with this.we receive bookings via phone calls, emails and online booking forms. All bookings are recorded in Google Sheets Each booking is assigned a unique booking ID which is alphanumeric eg. ABC230101 We would like all bookings received from the online booking forms to automatically generate the next booking ID in the sequence i.e. ABC230102 and populate Column B in our Google Sheet. We’ve looked at Formatter and Storage by Zapier however, none of these are working for us. With Formatter, we tried the INDIRECT function from Excel/Google Sheets however, it seems this is an unknown function for Zapier.Any help in resolving this would be much appreciated.

4
R
1 year ago
B
BBG-JNew
asked in Troubleshooting
Asana to Evernote

We setup a zap so that when a new project is added to Asana it will create a Notebook now we want to set it so that when a new task is added to a Project it will write the task to the coresponding Notebook. Are we going to need to set up a Custom expression?

4
B
1 year ago
K
KevinCritNew
asked in How Do I
How do I automatically have a Google Sheets formula used from the previous row?

I’ve setup a Zap to check a Dropbox folder for new files.Then the file name of the file is inserted into a Google Sheet. Now I need to figure out how to automatically have columns from the preview rows used for the new row. 

4
R
1 year ago
S
StarrfocksBeginner
asked in How Do I
Utilities Formatter Case Sensative?

Is the lookup table on the Utilities formatter case sensitive? I have “Alabama” in the table but it isn’t working if the field is alabama. 

4
R
1 year ago
Q
qwexecotlesNew
asked in How Do I
BookingKoala new bookings trigger a new job in Jobber?

I am trying to see if it is possible to have new bookings created in bookingkoala to be sent to jobber and created as a new job. Thus this should sync the calendars together

4
christina.d
1 year ago
N
Ninjamonkey777New
asked in Troubleshooting
Google Sheets - Status Code 400 Bad Request

A zap that has been working for 4 years is breaking and I cant work out why - the error message is Status Code 400 Bad Request and the info given is this:ProblemYour Zap is likely to be missing a required field, or a field value wasn't in a recognized format. For example, if a field in your action step is expecting an email address, but the value given is a name, the app may return a 400 error.SolutionCheck that your fields are correctly set up and mapped to each other. What i cant make sense of is that my zap IS sending the data just fine. It arrives in the sheet! All fields arrive and all data is correct. Any tips?

4
diegovsneo
1 year ago
Jamie Reynolds
Jamie ReynoldsBeginner
asked in Code & Webhooks
Airtable Automation - Deleting Values in Records

Hi Zapier Community 👋I am struggling with a challenge that I would love your help with!Context:I co-founded the business PS Bridal to help brides find their perfect wedding dress, for free. We use Zapier to automate a lot of our internal processes - and I am trying to setup a new automated process for a platform we are about to launch to help brides rent their perfect wedding dress.Brides will visit a marketplace where they can view dresses for rent, select a booking period and order the dress via our platform. The platform itself is built using the following:Front-end: Webflow Back-end: Zapier, Booqable, AirtableChallenge:The automation that I want to create will enable us to automatically update a dress’s rental period availability.The flow is this:Bride books a dress on Webflow Booqable receives the booking Booqable triggers a Zap which updates the dress’s availability in Airtable The Zap triggers a sync between Airtable + Webflow’s CMS to update that dress’s availability The dress

4
Jamie Reynolds
1 year ago
S
sallinNew
asked in How Do I
Google calendar start date and time

I’m trying to schedule an event on google calendar based on a project date.  I have this:1. Start Date Pretty:Jan 10, 2023 -5d 5:00pm Jan 10 as the start date, so I would like to schedule the event for 5 days before at 5pm.  However, testing the action showed even created Jan 10, 2023 at 5:00pm.  It looks like -5d was not read.  Any idea as to how I can work with this?  Thank you in advance.

4
S
1 year ago
M
mycarnivalmatchBeginner
asked in How Do I
Hiding email address between buyers and sellers

This question was split from the post  Hi @Mattieman! I don’t readily have WooCommerce to test with, but can you try using the Formatter app, then select Utilities, then Line-Item to Text? You would map the field you’re showing above, then select what you want as the output. That should give you some options to “convert” what’s currently in that unusable form, into text you can filter on :) I have set up a Zap for buyers to contact sellers on my site. Can I also try this to hide their email address from each other?  

4
M
1 year ago
M
Mohini KumarBeginner
asked in Troubleshooting
Unable to link Airtable with Discord!

Hello Community, happy holidays!  I wanted to ask you all for a quick support. I wanted my Zap to assign a role to a new discord user, when they fill out a form on Airtable. I have linked both my accounts, however, I’m unable to proceed through this section, as the username field is taking the Airtable ID, and not the column that has the Discord username. Could someone help?   

4
jesse
1 year ago
O
OzzyJMBeginner
asked in How Do I
Deleting event from Calendar vs Changing a meeting host

Hello Everyone. We established an action to change a certein field in Lead where the trigger is deleting an event from Google Calendar. However,We noticed that changing a meeting’s Host also gets noted as a deletion of that event by Zap.is there a way to distinguish a deletion of an event in Google Calendar from changing the meeting’s host?

4
SamB
Community Manager
1 year ago
K
Khan GBANew
asked in How Do I
Default insert data option will post both value fields rather than 1

Heya, I’m trying to insert a specific field (1) using {{Embeds Fields 1 Value:}} but it’s returning an exclamation mark. The default is “Embeds Fields Value:” which gives too much information. How would I fix this? The action is a post to Facebook with my trigger being a message posted in Discord. TIA

4
SamB
Community Manager
1 year ago
M
M.MckennaBeginner
asked in Troubleshooting
Zap problem on Gmail: You are not currently logged in

Hi there,We created a Zap that triggers when a new Webflow form has been submitted. The data is coming alright from Webflow, but then I test the Gmail part (action is to alert someone via Gmail) and Zapier displays the error “The app returned "You are not currently logged in".” which we can figure out why as Gmail is linked and logged in.Are there any extra steps we have to complete from Gmail or something?Thanks

4
Baldur
1 year ago
Rando
RandoBeginner
asked in Troubleshooting
Contacts+ to Mailchimp "Required field "Subscriber Email" (email) is missing"

Hello,My goal is to add/sync all existing and new contacts from Contacts+ to a Mailchimp Audience using the Trigger “New Contact in Contacts+”. The Audience in Mailchimp is currently empty.I keep running into the error 400 “Required field "Subscriber Email" (email) is missing“.I’ve read everything in the web but I cant wrap my hear around the meaning of: “ The email address of the subscriber you want to subscribe to this audience. Please don't type an email address in this field, instead this should use a value from a previous step in your Zap”. Ive tried to “map” this "Subscriber Email" field to how Contacts+ is internally naming the column of emails “E-mail 1 - Value”. Ive also inserted Data: “1. Work Email:”. No success. The only way I get the Test Action successful when I enter a concrete email address, but this in not the way to go.Can you please tell me what is, in my case, this value and in which previous step? Or otherwise help to achieve my goal.Thank you,Rando 

4
Rando
1 year ago
V
VinciiBeginner
asked in Code & Webhooks
The app returned "An invalid api_key was supplied. Error

Hi, I’m trying to connect Price labs with webhooks but I keep getting an error message:Failed to create a request in Webhooks by ZapierThe app returned "An invalid api_key was supplied.when I’m using the url:https://api.pricelabs.co/v1/neighborhood_data? Params:pms=vrmlisting_id=SUNSETPROPS_OLSE___239 I’m using basic auth: Username|API KeyHeaders: X-API-Key = API_KEY_FROM_DASHBOARD And when using it with url: pricelabs.co/pricing it’s successfully connected and pulling data but incorrect.

4
V
1 year ago
R
rickaltmanBeginner
asked in Troubleshooting
Error: Failed to create an email to Microsoft Outlook, Unable to send an email: Resource could not be discovered.

I am reconfiguring an existing Zap -- directing it to a new Google sheet that has an identical structure -- and in testing it, I am hit with the now-dreaded “Resource could not be discovered” error messages. Zapier says I should check to make sure all fields have the right kind of data; they do.What other things should I look to in order to defeat this error?

4
chanelle
1 year ago
L
LorenBeginner
asked in Troubleshooting
Zap Filters Not Triggering When Flipping from One Word to Another

I am having an issue with a Zap (that used to work and now doesn't seem to be working properly ...) and am hoping someone can help.Context:I have a GoogleSheet that gets automatically populated with new customer data. We have a column (BI) with "Yes" and "Email Again" as separate dropdowns. The zap is set up to be triggered when BI is updated (we select "Yes" or "Email Again" manually when we want it to trigger). The Filter in the Zap checks to see if it is either Yes or Email Again. If so, it proceeds. The action it is supposed to take is to pull in data from the spreadsheet and plug it into Mailchimp. When the zap runs, that piece all works fine. The issue we are having is getting the zap to run properly.There are three issues that I am trying to solve for - I've listed them in order of priority:1) "Email Again" not triggeringIt seems that typically "Yes" triggers fine (>90% of the time). However, when we then try to flip it to "Email Again" the zap does not trigger again (even th

4
christina.d
1 year ago
R
Rlaurence83Beginner
asked in Troubleshooting
Extract URL Text in formatter - CloudConvert - Descript

Im trying to extract a URL from a cloud convert file to then use to request a transcription from descript.  Im not sure what function to use to do so. Currently the steps in the zap are    i either get a 403 Error or a Not a valid url for a .mp3 any help would be much appreciated :) 

4
SamB
Community Manager
1 year ago
J
JC_princessBeginner
asked in How Do I
How to generate the daily article, and post on Linkedin

The current approach is using an open API key and integrating with zapier schedule and Linkedin, but my point is Content URL. How if the post is a daily build, and I can fill in the unique URL in advance

4
rachael.silvano
1 year ago
J
Joshua MursicBeginner
asked in How Do I
Update Inventory Levels In Quickbooks from Google Sheets

Hello, I am trying to have Google Sheets send information to QuickBooks regarding inventory levels, but i do not see any fields for updating existing products in Zapier, only to create new ones. Is this something that is not supported? Maybe a work around could be to delete the existing product and just create a new one with the new quantity that I have? Thanks in advance.Kind regards,Josh

4
christina.d
1 year ago
A
AngelzapNew
asked in How Do I
How do I change {{Zap_meta_human_now}} date format to UK standard (DD/MM/YYYY)?

We are using DD/MM/YYYY as we are in Australia. How do I change {{Zap_meta_human_now}} date format to UK standard (DD/MM/YYYY)?We also not want to use formatter because we only using {{Zap_meta_human_now}}

4
christina.d
1 year ago
T
Tanya1992Beginner
asked in How Do I
Advanced Excel formulas

Hello everyone. I need a hand with creating automated sales reports.There is much information I include in weekly reports, but let me walk you through one metric. The process goes like this:All leads that end up in a CRM are also recorded in an Excel sheet (this is automated with Zapier). The information included: first and last name, email address, and date. On a weekly basis I create a report where I summarize all new leads and add a number to the report. This is done manually, I go to the Excel sheet, CTRL+F, type the date and find how many new leads ended up in a Sheet on a specific date. This is basically the COUNTIF formula in Excel, but I would like to automate it with Zapier.How can I automate the 2nd step?  Thank you!

4
T
1 year ago
R
rafaelrodriguesBeginner
asked in How Do I
Freshsuite field to be updated when the linked business is updated in Google Sheets

Hi,I have a database on Google Sheets that is updated every day for to customer payments, and would need when the "Payment Status" is updated in the Google Sheets lines, Zapier would send this information to Freshsuite and update the already created field with the new information: PAID. This way my automation of billing to customers would end, as we received payment from them.As I can read the "Payment Status" column in Google Sheets, and when identifying that Customer X made the payment, Zapier updates the Field in Freshsuite.Someone help me? I've tested numerous hypotheses and failed. :( Prints:  Example of Google Sheets database. Column H will be updated every day with the Payment Status of each customer (identified in column A), installment (column B). When updating to “PAGO” (paid in Portuguese) Zapier would send the information to Freshuite with "Payment Status: PAID", finalizing my automation.     When updated in Google Sheets, this field circled in Yellow would change the Statu

4
chanelle
1 year ago
R
Rodwill1707Beginner
asked in How Do I
How do I automate my Facebook page appointment system using Zapier?

I anm a total newbie from Naarm/Melbourne. I was advised to link my fb times to an appointment system, I have no idea how to do this, Help

4
jesse
1 year ago
Terms & Conditions