Find answers to your questions. Ask the Community for help or hire someone to help you.
Quickbooks Commerce - Notification when purchase order received in full
Hi all, I am trying to create a Zap that sends a notification via email when a purchase order is received in full.I can find triggers for sales order but not for purchase orders, am I missing something ?We currently have Quickbooks commerce, not QB online, is that a requirement for this ? On a side note would I be able to pull stock data daily from QBC and paste on a Gsheet using Zap ? A daily SOH report. Thanks in advance
Can Zapier Pull Youtube videos to share on IG?
Hi Im trying to find a zap tutorial that enables you to take videos uploaded to a channel and upload the video to IG business. The few times I have tried I have gotten an error in the zap. Also It is telling me to do the image instead of a video, when i specifically want the video moved over. Any suggestions?
Lookup first blank cell in a column Google Sheets
Hi there,I am attempting a Zap step using ‘Lookup Spreadsheet Row’ in Google sheets, and I cannot find a way to tell Zapier to look for the first blank cell (or cell with no value) in the search column (leaving the ‘Search Value’ field blank fails the step as a value is required). Is there an operator Zapier recognises that tells it to search for the next blank row/cell in a column?The broader challenge - I have a list of unique sequential IDs in column C, and I need Zapier to update a row to included new registrant details (such as name, email etc) when they register. Using the ‘create new row’ action simply inserts a new row below the last ID. I have also considered having Zapier assign a unique ID when it creates a new row, but I don’t know how to have it lookup the last ID in sequence and add the ID+1. I need the ID for later steps.Any ideas?John
New Email in Gmail to trigger SMS to list of recipients
We have a restaurant and currently we send daily texts from a cell phone for our lunch and dinner specials to a large list of customers. I wanted to automate this some and use the Send SMS messages from Clickatell for new emails received on Gmail option so we can just send an email that will trigger an event to send a text. I have it all setup but the problem I am having on the Setup an action form, the TO only allows one phone number to be entered. I tried to add additional phone numbers separated with a comma, colon or a space and it’s giving an error.If I use just one phone number it works just fine. Any idea on how I can accomplish this or if there is a different zap I can use with my clickatell account to send our daily specials?Thanks
Creating Zap for Indeed Applicant into Trello Board
Howdy! So my company is in the midst of hiring and we have all of our applications create a card in Trello so that everything stays organized. The biggest issue however is Indeed. I know there are currently no Indeed integrations - but I am wondering if anyone has found a work around. In the Indeed email it includes our Screener Question with Answer, and also a public link to the resume that does not require a log in. However when I set up a Zap through gmail to create a trello board when someone applies through Indeed, in the “data” section to add into the trello card, there is no data containing that screener question and the public link to resume. The only data available to choose is a generic link to indeed (not the specific resume) and no data on the screener question. Has anyone figured out a clever way to make this work with Indeed and Trello? I tried searching in the community and google, but to no avail. Thanks!
Automate detection and parsing of flat file from FTP to marketing automation tool
Hello Zapier Community,Several year user of Zapier and automations to connect multiple sources like Unbounce, MyEmma, SurveyMonkey etc.I have a new challenge that I’m not sure Zapier is up to but thought I would ask the community.We are working with a third party to create a daily email list that is based on a triggered action within their proprietary platform. At this time they cannot expose their output endpoint API to us and can only auto-generate a daily flat file and place it on a site (Exavault hosted SFTP or Box being our two preferred locations).My problem is that this flat file will contain hundreds to thousands of emails. One per row.I would like to perform the following workflow within Zapier if possible. Watch for a new file in a consistent location in either SFTP server or Box. Same file name each day. When the new file exists, parse each row as a unique zap action. Hand off that email to our ESP (MyEmma) via their API (already know how to do this and am currently using
Facebook Leads not adding to Mailchimp audience
I created a Zap to import Facebook Ads Leads into our Mailchimp audience but they don’t seem to be getting added to Mailchimp. I’ve tested the Zap trigger and it’s pulling data properly from Facebook. The Zap action also seems to be working after testing it.
Weekly Slack Message with upcoming event names and attendees
Hi folks, I’m working on a way to bring event data from Eventbrite (or HubSpot, as they already talk to each other) to Slack. I’d like to send a Slack message to a channel on a Monday morning saying: Here are our upcoming events, and here are how many people registered for them (as a list). I think my query would rely on a webhook getting data from Eventbrite, but I’ve not found any clues as to whether or not this is possible at an organisational level. I can pull data from an individual event no problem, but what I’m trying to do is pull data from ALL our events.Any ideas?Thank you,Oli
New database (Bubble.io?)
Hello everyone,I wanted to get an idea of what everyone else is doing out there in regards to utilizing a solid database. Right now, we use a lot of Google Sheets. Obviously this is not the optimal database source and we’ve been hitting issues since various sheets are getting big. We have looked into Airtable, but we’re also recently started utilizing Bubble.io. I know they offer a database of some sorts and wanted to know if anyone has used them as a database source or have found/use a reasonably cost effective source? Any input is greatly appreciated!
Sending Salesforce data to Google Forms as answer options
Hi,I tried Zapier today to update the Salesforce records based upon the customer response on the Google Forms. However I am looking for a way to send the Salesforce Data as the answer options in the Google forms. Is this possible via Zapier integration.
Limit Batch Size: Salesforce
I use Zapier to send giving data to our CRM. We have lots of recurring donations so we have sometimes hundreds that process at exactly the same time. My CRM has trouble keeping up. How can I limit the number of zaps sent at a time… so that for example they go over in waves of 20 instead of 120 in the matter of seconds?
EKM to QuickBooks Zap - how to reduce task usage
I have a Zap that links EKM Sales to QuickBooks to create a Sales Receipt. To make the zap work I have 5 steps that convert the VAT rate to a code (the receipts tend to be split rated) for each line item (number.spreadsheet.formula) work out the price before VAT for each line item (spreadsheet formula), work out the delivery before VAT (number.spreadsheet.formula) and each line’s subtotal (Utilities) Work out the code for the bank the sale has been sent to (paypal or current through Stripe) (spreadsheet formula)This means each zap is 6 tasks and eats it’s way through my allowance quicklyIs there any way for me to combine these tasks?
Adding Pardot to Already Configured SFDC Web form to SFDC Lead Zap
Hi Everyone, We recently purchased Pardot, and until we can get our Pardot forms filled out and put the code on the new website we are building, we’d like to link Pardot to our current Zaps. Currently we have Zaps that are initiated by a gravity form being filled out on our site which then creates a lead in SFDC. I was hoping to just be able to modify our existing Zaps to link to the correct Pardot Campaigns somehow. I see that Pardot fields are now avaialbe options when I open a zap to edit it, but was not sure what value i should put in there. Or if what i need to do is add another step to the zap and connect Pardot and update it that way. Thank you for any help and guidance anyone can give.
Retrieve Most Recent Comment from Jira Service Desk
I’m currently setting up a Zap to post comments from Jira Service Desk / Jira Service Management to a Zendesk ticket when the Jira Request is updated.This was working pretty good! A zap first creates the request from Zendesk in Jira Service Desk and stores the Zendesk ticket ID in the request. Then when the request is updated in Jira, it updates the Zendesk ticket with the Jira Request Status and the comment.But then I tried adding more than one comment to the Jira Request.Instead of grabbing the most recent comment from Jira, it grabs ALL the comments on the request. Oops! From what I can tell, when using the field that would contain the text of the comment, Zapier is grabbing every instance of that field in the array that’s returned from Jira.Does anyone have any insight on how to grab just the last item (most recent comment) from the array returned by Jira? Thanks! The zap is currently set up as follows:Trigger: Updated Request in Jira Service Desk App: Jira Service Desk Trigger Ev
Unable to see records in Salesforce
I tried integrating Salesforce and GovSpend applications together. I used the paid account for GovSpend and trial account in SalesForce. The zapier says data is sent to my salesforce trial account. But I am unable see the data in salesforce.I just want to understand the problem. Can you please help me figure out the issue?
Webflow submission - SMS - Airtable flow
I have a webflow form submission that I would like to kick-off a series of daily sms messages which I have in a table in Airtable (1 message each subsequent day from the day a user signs up), and send these from my Twilio account. If anyone has an idea of how to set this up in Zapier and how to format the Zaps and/or Airtable/Twilio side of the house that would be great to hear!
Policy Acceptance: Attaching Google Doc to Form
I’m trying to build an integration between Form, Docs, and Sheets where employees can review and sign-off on corporate policies (e.g. code of conduct). An employee could go to the Form, enter their name / date / etc, click on a hyperlink to a policy in Docs, review the policy, “sign” the form (e.g. input their name / check a box/ etc.) and click “Submit” (which would then populate a Sheet for record-keeping purposes).If anyone has any thoughts (or has solved this) please let me know.Thank you!
exporting old data from airtable
Hello . The zap I built does the following: every time a new record appears in airtable and it exports it to a google sheet.Trigger is 1. New Record in View in AirtableAction2. Create Spreadsheet Row in Google SheetsAction3. Update Record in AirtableThe airtable view I am using has some filters, for inctance if a specific word is part of a slack incident channel name, year is 2021, 2020 and 2019I would like to be able to export data from previous dates, also from last year.
Attach Gravity Form submission as pdf attachment to Salesforce record
I have a zap connecting gravity form and Salesforce, data integration is working perfectly fine.I am looking for guidance on how to bring completed form as an attachment to a Salesforce record ? is that possible ?Couldn’t find any knowledge articles around this topic, appreciate any of your inputs here. Thank you
Already have an account? Login
Use your Zapier credentialsLog in with Zapier
Log in to the Community
Use your Zapier credentialsLog in with Zapier
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.