Solved

Hi Zapier community, how can i let Zapier to add new row to the TOP of Google Sheets instead of the BOTTOM? Thank you.

Hello. I am using the Webflow platform and have a page that needs to load a form generated from a client’s API. I ran this by Webflow Support, they suggested that Zapier could help with this. Is this possible to do with Zapier? If it is, I don’t really know where to start or how to go about it so some guidance from somebody that knows how to go about it would be really appreciated.CheersGrant

Hi all, I have created an apps scripts and already getting my web app URL:https://script.google.com/macros/s/******/exec?searchStringName=doPost My use-case is:Whenever my google spreadsheet is updated, I would like to run the above URL so that it can generate PDF file automatically. I am using Action>GET Webhook, and getting this as result: However, the URL is not being executed. Any insight on this? Thank you in advance! Best regards,Leo

Hello!everyone!Im sorry Im not good at English.The 2weeks trial has ended.I moved to the free plan, but the monthly task is 50 instead of 100. When will it be 100? Thank you!

Hi everyoneI use Xero as my quote tool. When a job’s quote gets accepted by the client, I want Zoho CRM to update the status of the job.Currently there is a Reference Number on the Quote (eg. JDP-1001)  that is the same as the Job Number in the CRM Deals module.I know you can use filters to get individual records... what I need is a 2-way filter that matches the Reference Number on the Quote (in the trigger) against the Job Number in the CRM (in the action) and updates the CRM to let the CRM user know the quote is accepted.This doesnt seem to be possible with the current architecture....

So I have a catch hook from a partner site that is triggering an action / webhook by Zapier request to our site(WordPress). This webhook(Custom Request POST) is sending a raw json payload that consists of a few simple items for a REST API that is part of WordPress plugin(myCred).It’s making the initial handshake but I am getting an error in response:Error: Access Key, User ID and Request Type RequiredAll of which are in the payload and verified by testing on requestbin. I am not sure if there is possibly a format issue or something I am missing but the json is formatted accordingly to the documentation of the plugin.Here is my payload with the obvious redacted info: This seems terribly simple but I’m definitely missing something. Thanks for any eyes on this. I appreciate it. EDIT: Thought I would add their endpoint documentation for reference.  

I use zapier to track tips for my fleet of drivers since my logistics software doesnt support it for some reason. The drivers name can only come in as some very long code that I have to translate. I made a new sheet with a simple table that connects the Driver ID and the human readable name. =iferror(vlookup('Data Ingestion'!A2,'Driver Keys'!$A$2:$B$45,2,false),"")The “A2” value should go up to A3 and A4 and so on…When zapier enters a new row, every single one of my formulas “AX” value gets bumped out of place. So A2 that is trying to refer to the corresponding A2 on another sheet now refers to A3.My theory is that since zapier enters a new row instead of filling the next row, it tricks google sheets into adding one to everything every time a new row is entered.Whos bright idea at Zapier was it to enter data like this? You cannot refer to data entered by zapier in a formula because of this. Makes the entire thing useless

Has anyone successfully figured out how to trigger a Zap where a new Quickbooks Online SubCustomer is created for a client? We only see how to create the Customer, but not the SubCustomer.

Hi, I created a zap in order to automaticaly creat a new contact in Pipedrive whenever a new person is added to a specific MailChimp audience.The zap is working as intended except for the organization part… All the other informations are in the Pipedrive contact but the organization. I also have a zap between gsheet and mailchimp with the same exact same informations and fields and here the organization is succesfully displayedThe question here is why with the same merge field from Mailchimp, the organization fields works with Gsheet but not with PipeDrive. If one of you already had the same issue or have any information about this issue, i’d be glad to talk with you :). I can provide further more informations if unclear or needed. Regards,   

Hi everyone.I’m currently creating a zap to auto-update clickup tasks with comments made on pipedrive. The problem is that we have to choose a certain task rather than allowing to automation to find the right task to update on its own (if that makes any sense). I tried using the filter tool, but it doesn’t do what I need it to.So tl;dr: is there a way to make zapier find the right clickup task to update?Thanks!

My company uses Stripe with many of our clients. We have 1 phone number that is linked to all accounts and our team is constantly asking what the 2 step code is to login to Stripe account. Is there a way to connect to Slack so we get codes there versus someone having to manually add to stripe for team member requesting code? Thanks so much!

Hello everyone. I had zaps running with Catch Hooks getting data from an automation program which pushed data and then Zapier processed that into Trello. But I had those webhooks running during my 14 days trial and forgot to purchase the premium license when it ended (which caused the zaps to shut down). Question is: if I purchase the premium license now and reactivate the zap will it be able to get all the data that was pushed during the time the zap was deactivated? Thank you.

Im Trying to connecgt google sheets to firebase firestore. Im trying to combine multiple columns to form an array in the db.  But I dont see an option to choose the datatype of the data being store. All the fields are stored as string.  In the below example, I want to store imag_url as an array.  

I want to track our email volume and responsiveness.I want to measure: how many emails we get by date, what type, lead source and response time i excel.  I would like to be able to drop and drag fields from outlook into an excel field.  Can someone help guide me here?  Thanks!

Hello,We want to connect woocommerce to zapier and want to automate within certain categories and I can't find in the docs if this is possible. Is it possible within this app to set triggers based on a product that has been added within a specific category? We would like to be able to make an automation based on when a new product has been added within the category "Occasions".  Sincerely,Sanne

I made a zapp to connect Woocommerce to the emailsystem. I have mutliple products in Woocommerce, which should by connected each to their own list. I choose ‘order’, but there is no choice for a product. How can I choose a purchased product as a trigger?Thanks in advance.greetings! 

How do I sync existing Dropbox folders to Pipedrive, Hubspot, or Salesforce?  I am in the process of purchasing ad setting up a CRM service.  Is it possible to sync an existing Dropbox contact folders to any of these CRM?e

Hello! I have a zap where a client submits a google form response > Find Many Rows uses two of the form responses to find rows in an existing Google Sheet > The bottom 10 returned rows are formatted and sent back to the client using the email they provided. Find Many Rows can find and return UP TO 10 rows, but is there a way to limit the number of returned items so the client only receives 5? I don’t see an option for that in the step itself, and struggling to come up with filter logic that would accomplish that. Thank you in advance!

Hello, I’m trying to create a zap to insert new client payment from stripe into a google sheet; however, the stripe options for at the amount paid and description of the product aren’t appearing in the options of the dropdown menu Any ideas? 

hello,i am trying to post my latest uploaded video posts on instagram to Pinterest.I test the media link and it is valid the video can be opened in my browserThis zap should be for videos too it says media not pictures in the description.Any tips for me ? Am i doing smth wrong? Help is appreciated. Thank you 

Hi,I am interested in triggering Zap upon update on contact record in SFDC.  Is it possible? if yes, how can I achieve this?

I am using Google sheet for multiple partners, A column mentions the partner sheet id.I wish to trigger my master sheet in such a manner that a partner receives data relevant to them.while setting up the action, in spreedsheet field, I am passing a custom entry of the partner sheet id.The worksheet field throws an error “Unable to load choices”.How do I make the spreedsheet field dynamic?

I’m thinking of setting up a shared Google Calendar for my Discord server, and in a perfect world, would automate so that every non-recurring event created on it would automatically get a Discord channel opened with the same name as the event. For instance, “Friday Night Gaming” gets created on the calendar for 6/18, and a new channel shows up in Discord called “#friday-night-gaming-06-18”. However, don’t see the option to create channels from Zapier...does anyone know if something like this would be possible?

Hi folks,sorry for opening a new request, but I guess it is not very smart to combine two questions in one post.I would like to tell Zapier to update informations on Trello cards (in the card name and/or description) as soon as something has changed in a Google Contact (e.g. card name is the name of the contact, card description contains phone number, e-mail address etc. - if I correct the spelling of the name or add another number, I would like Zapier to edit those informations on the Trello card instead of duplicating the whole card).I have tried to work with paths and designed one path for a new contact (=create a card, filter: "update time doesn't exist") and one for an edited contact (=update card, “update time does exist”). Unfortunately I am struggeling to set up the right action. I chose the correct board, left the list value empty (cause I want to update every card on any list as soon as there have been changes) and at the point where I have to pick a card to update, I struggl

Hi,I’m sending every day new Google Form for daily “working hours” that each employee have to fill and i would like to automatize the questions on a personal and always the same big Google spreadsheet (for each employee). How can i manage it?Thanks!!