Find answers to your questions. Ask the Community for help or hire someone to help you.
Create multiple rows in Google Sheet - parsed from line items in an email
Hi EveryoneI’m familiar with using email parser to move data via a zap into a google sheet. But my issue now is I want to polulate a number of colums with several rows of data, instead of just one new row - specifically, it’s a timesheet email which has data for each day of the week. The data needs to go into specific columns, but I also want a row for each day. The email parse contains data for every day, Monday to Sunday, but currently, the zap will only pick up the first day, ie Monday. Any ideas?
What workflows can be built between Tovuti LMS and BambooHR?
Hi Team, hope you are all doing well. I just have some concerns since we are planning to use Zapier to Integrate Tovuti with our Bamboo HR Account. Just wondering what can we integrate with Tovuti and its capabilities using Zapier? Thank you so much! :)
HubSpot Deal Trigger delay
The Zap of Hubspot and Slack is perfectly working for all the deals from Hubspot. But for a particular deal, the Zap appeared after 2 months instead of instantly. Can you please help in figure out what exactly could have went went wrong as the Zap is working perfectly for other deals? BestAm
New Reaction Added trigger - using a custom value
hi!!I’m creating two Zaps that start from a new reaction added to a slack message. The 2 reactions I’m looking for are `:eyes:` and `:white_check_mark:` 2 regular emojis. However I can’t seem to be able to set them up, I only can see the custom emojis and on the Custom tab I can type or select a thing despite it says select Use a Custom Value What am I missing? I’ve attached 2 screenshots. Do I need to just read all the reactions and filter them out? Thank you
Is Free plan ok for me or do I need the starter level plan for Zapier
I will attach a screen shot of my Zapier account. I just have some webinars I do and have my contacts moved from the webinar service to my Active Campaign Master List. Am I ok with the Free account? In the new series of my programs, I will have 4 webinars in a week to do and again move these contact that sign up for the webinars over to my Active Campaign account via Zapier. Is the Free amount ok for me to do or do I need the Starter account? ok, I attached my screen shot of my Zapier account
Shared Drive (G Suite) URL ID not working in zap
I understand there is a thread about entering the ID of a shared GSuite Drive (Team Drives). When I do so in a Google Sheet - Google Doc Zap, however, I get an error and the Zap says the ID is unrecognized. This is the full URL https://drive.google.com/drive/u/0/folders/0ANc4NG3iRUoPUk9PVA I am entering 0ANc4NG3iRUoPUk9PVA in the custom line.
Magento 1 to QBO Invalid Line TaxCode in the request
I am trying to create a zap to Connect Magento and QBO to create an Sales Receipt when I get a new order. I keep getting this error about the tax code “Invalid Line TaxCode in the request“ no matter what I choose. See screenshot for all my available taxcodes
Updating bottom row only before adding new row weekly
Hello!I´m having difficulties achieving the automation I want.This is the scenario: I have a google sheets document. One of the sheets are updated hourly with Pipeline API. The data I´m importing is always just a total amount accumulated over time. What I want is to divide this amount in weekly amount accumulated. So I want to know what the total was in each week. I don´t want to know how much the total increased each week, but how much the total was accumulated in each particular week. So say it´s 4 this week and next week it gains 2, then I want the row for next week to show 6 and this week to still show 4. Now I have my sheets document set up like this:Week Number Amount=isoweeknum(today) “Link to the cell in the sheet that is automatically imported” So what I want to do with Zapier is: Every monday at 2 am replace the formula in the bottom row with the actual data. And then at 3 am add new row with the same formulas. The adding new row bit is quite straightf
Google Sheet Permissions on copied spreadsheet using Create Spreadsheet action
Hey guys, Need some help here. I have a step that creates a new spreadsheet from a template. The problem is this newly created worksheet is set to private and inaccessible by other members of my team. I have already set the template permission to literally anyone with the link can access as I thought the newly copied spreadsheet permission is copied from it. Can someone help please? I only want the new created sheet write-accessible to anyone with the link.
New vs Updated Subscription Data from Woocommerce to Google Sheet
Issue: getting subscription data out of Woocommerce to analyse in Google Data Studio. This needs to be done Zapier because Woocommerce doesn’t export this data into a google sheets. Goals:create new subscription (DONE); update subscription when renewed (NEED HELP): how can one update only some of the rows when a subscription is renewed, and can the revenue which comes from the renewal be updated to add the revenue of the renewal to the first revenue generated through the customer buying the membership for the first time? Update total_revenue & next_payment_date etc.
Mail to Airtable - problems with attachments
I am trying to send an email to airtable to create a new record. This works well except it does not properly do the attachments. I have tried this with both Gmail (upon label) and using the Zapier mail function where you forward an email to Zapier. In both cases, it creates the following kind of attachment rather than actually attaching the files I need. Ideas?
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
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.