Tips and Inspiration
Share and explore knowledge, tips, and cool projects .
- 211 Topics
- 513 Replies
Save a Step by Adjusting Date/Times with ModifiersRecently came across this handy help article (copied below): https://zapier.com/help/create/customize/adjust-date-and-time-values-in-zaps ### Adjust date and time values in ZapsLast updated: February 09, 2020You can adjust the date/time values in date/time fields by including a modifier after the date/time value.A modifier includes:A + or -, signifying forward or backward in time A number A unit of time: s (seconds), m (minutes), h (hours), d (days), month (months), y (years)For example:+7h - 7 hours after the date/time in the field. +10d - 10 days after the date/time in the field. -45m - 45 minutes before the date/time in the field. +30s - 30 seconds after the date/time in the field. Useful if you receive a duration in seconds. +1y - 1 year after the date/time in the field.You must include a space between the modifier and the date/time value.Multiple modifiers can be used together, and must be separated from date/time values and each o
If you’re going to ask a question, give yourself the best shot of getting replies and resolving your issue as quickly as possible.Be descriptive and include helpful detailsIf all you write is “My filter step isn’t working” you will inevitably have someone respond asking you for more details. Imagine what someone might ask you based on what you wrote. If there are unanswered questions that you could be proactive about, please include that information.For example, with the filter step above you could include a screenshot of the Zap, or of the Zap History, explain when it works and when it doesn’t, explain what you’ve tried so far, when the problem started, etc.If you’re seeing a particular error message, please include itInstead of: “My Quickbooks Zap is broken- HELP!”Try providing some context so that you receive better, more timely assistance: When I test my QuickBooks step in the Zap Editor I get this error message:”Make it easy for others to help youAsk yourself:What would I want to
Did You Know (DYK) most Zap app integrations are maintained by the app developer, rather than Zapier.Be sure to keep that in mind, when suggesting feature requests to Zap app actions/triggers/searches as well as reporting issues.In many cases, it would be best to direct such feedback to the Zap app developer regarding their Zap app integration, although Zapier welcomes feedback about Zap apps.
Hi all, Is there a way that I can have some fields move from one Google worksheet to another worksheet in the same Spreadsheet after 6 months have passed since the date in the field? To give context, I want to create a zap to help me track inactivity from Meetup groups. So far, I’ve created a zap to put the Meetup event and date in a Google Spreadsheet, in the worksheet called active 6 months. After 6 months have passed, I would like to move the fields taken from Meetup to another worksheet called active 1 year, after that year has passed, I’d like to move the fields into a final worksheet called inactive. I’m having issues using time as a trigger for the zaps. Is this even possible?Thanks.
Is there any integration that can help us to send an automatic email (gmail) if the receiver doesnt reply in a week to our previous email? The reason is that, sometimes, our customers that asked for an estimate, after receivng it, don’t even reply. So we are wondering if there is any way to remind them that we are still here. Sent invoices are automatically tagged as “sent estimates”. Thanks
Hi there ,We provide Field Service Management solutions based on IoT. We automate on-demand service requests and time tracking on the field with IoT buttons.Like this one:In the past, we were using webhooks to connect to Zapier. We made a lot of demos in IoT conferences to show the power of Zapier associated with IoT.With the COVID, we had an increasing demand for traceability and cheap contactless solutions. So we built a platform called Ubiqod, that works with both IoT and QR codes, and we made a brand new Zapier integration.There are many use cases:Time tracking (i.e. remote workers) On demand services Asset tracking Customer feedback ...Here is a tutorial for on demand service (industrial dumpsters): https://www.ubiqod.com/docs/zapier/#what-we-want-to-achieveYou can register for a free account here: https://admin.ubiqod.com/#/registerInvite link: https://zapier.com/developer/public-invite/117420/f05479c250f90fc13dd566544df205e0/We would love to have any feedback from the community
Hello everyone,Back with another integration. This time inspired by this question and since this feature isn’t supported by the built-in Storage app, I decided to make a custom one.Introducing KV Store, a custom Storage integration that uses the Zapier Storage REST API behind the scenes and supports an instant trigger for when a value is created or updated!Currently, it only supports the following triggers and actions but I will be adding more in the future.Triggers: New or Updated Value Actions: Set Value Invite link: https://zapier.com/developer/public-invite/124310/02e450e492d94e83e4480ba74499384d/ ZAPIER SAYS: This is an invite-only integration, created by a dedicated member of the Zapier Community. It is not publicly available, nor is it created by Zapier directly. Any questions/suggestions should be addressed to the creator, as they would be the best person to act on the feedback Thanks@ikbelkirasan for your hard work and for sharing with the community!
When Covid started getting real, our company, like many, went fully remote. We are a remote research firm with 75% of our work in person. In order to ‘save the 75%’ we all did what we could to help. For me, that meant putting my Zapier skills to work.One of the bigger time drains we identified was the process of manually creating Zoom links. We do a ton of research over Zoom and for every session, a Project Manager would literally login to Zoom, create a meeting, and then copy/paste all the meeting info into a spreadsheet. Given they create about 1,000 Zoom session links per month, this was my chance to make a difference.I went to work and created a solution I call the Zoom Sessions Generator. I thought I'd share it here.To start, I’ll share a Slack post I sent to our team the other day when we hit a major milestone… Technologies used* Airtable* Google Sheets* Slack* ZapierUsage'/sessions generate' (a Slack slash command I created to initiate the link generation) How it worksThe Zoom
Hi all,Just a heads up that the latest Vybit release now includes the ability to record your own sounds for your notifications! Also you can import your own sound files via local upload or web url download. So now the notification sounds you hear can be even more customized and meaningful. Heck, you can even just speak what the notification is, e.g., "New Tweet from George" or "Take out the trash, hurry!". Be welcome to post any questions here or learn more athttps://www.vybit.net and https://zapier.com/apps/vybit-notifications/integrations.Thanks, Brady
Has anyone had a chance to play with the new Google Assistant integration? If so, how have you found it? What workflows have you created? More importantly, how has it saved you time?! We'd love to hear your success stories, if you share yours you could be featured in our blog!
Figured this workaround out today but have been trying to figure this out for a bit so I thought I would share in case anyone else needed it! This is to create dynamic formulas that will calculate data as rows come in to google sheets. First use the create row step to create the row without the formula fields or with formula fields that are not dynamic. Immediately after this step, add another step to Update a Row. Use the custom tab to insert the row that was created in the previous step for the row to be updated then when you type in your formulas you can insert that same row Id where you would usually reference it in your formula. Voila! I hope that helps!
Let's say you want to send yourself a random motivational message each day, and you have a collection of inspirational quotes in a Google Sheet. We want to build a Zap that will trigger each morning and choose one of the quotes to send to you on Slack. Here's how you can do that.First, create your Google Sheet. For the first column, add the header 'Has quote' and have your quotes in the second column. In the first column, add this formula:=if(ISBLANK(B2),FALSE,TRUE)This will return the Value 'TRUE' if there's a quote in the quote column 'FALSE' if there isn't. You can copy this formula into every row - whether or not there's a quote in there now. Add your quote in the second column, and then add a third column called 'Row ID'. This third column will tell the Zap which Google Sheets Row each quote is on, which we'll need. Then create your Zap. In this case we're using Schedule as a trigger so that I can get an i
Hi All,I recently launched a new integration app on Zapier. Vybit sends distinct, custom sound notifications that you create by choosing from thousands of possible sounds (from freesound.org). The idea is that the specific notification sound itself tells you exactly what Zap trigger fired (and if making the effort to grab and look at your device for the notification details is warranted). Vybit is free and it also works with anything that has outbound webhooks. Please check it out including the Zap Templates, I think you will find it super useful! Questions and feedback are very welcome! Thanks, BradyVybit on Zapier
Hey everyone!I wanted to share a quick tip about an app that I just discovered. I received a notification for this Reddit post in the Zapier subreddit. Vybit enables you to find a sound that will be played in your web browser and/or their mobile app when your Zap is triggered.You can check out the integration here: https://zapier.com/apps/vybit-notifications/integrationsWays I can think of that you could use this:have a specific sound when you receive an email from someone you deem important hear something like a cash register (or an airhorn) when your online store makes a sale trigger a Zap using Shortcuts in iOS to play a sound on demand (on someone else’s device, for example) play a siren sound 5 minutes before meetings, to make absolutely sure you don’t show up lateI’m sure there are countless other ways you could make use of this :)EDIT: I see that the Vybit team added their own post in the Zapier Community as well...probably should have checked for that first, haha.
What is Upsert?UpSert is a Coda.io function that permits to OR create a new row OR to update a row if there is a match. I had a working solution for a while based on a Coda Row ID. The logic was like this:A form of Paperform was filled out and via Zapier the data was injected into a Coda table. When the subcriber wanted to update the info (via a link in an email sent via Zapier - > MailJet ) an Upsert took place based on a hidden field in Paperform that I had injected with a Coda Row ID. The creation of the Row ID and how to prefill the Paperform is not the issue here, I guess the reader knows how set this up.Coda and the RowIDWhen a form with a Row ID came back, the uspert took place. The handy thing was that inside Coda we had an automation running that created a duplicate of the RowID column. Due to this automation it was not a formula driven column so we could used it to set up a Match in Zapier. However after a while this solution did not work anymore. I created two solutions
I have been trying to figure out how to copy my Zoom recordings to Vimeo and although there were several topics on it, they made it more complicated than it needed to be, and didn’t give you the ability to easily name your Vimeo video something from Zoom. You can do it in 1 Zap. Zap Steps For Google Sheets I created 2 columns, one form the Video DL URL, the other for the Topic from Zoom (which I am actually getting from another Zap with YouCanBook.me and Zoom. Google SheetsI put a delay in just to make sure it is written to Google Sheets before trying to copy it to Vimeo. The last step was to then upload it to Vimeo. I used the Video URL from the above step from Google Sheets, and the Topic I grabbed from Zoom.
I have a suggestion: As of now all the filters stop the zap when the condition is false. By just adding a check box on the filter definition that indicates wether or not the zap should stop or skip if the condition is false, many use cases can be implemented without using paths or sub-zaps. With that one could say “if condition is true, then do this next step and then continue, otherwise skip this next step and continue or stop”. Much line true if-then statement. The conditional step could still be a simple action, or it could be a webhook into another more complex zap.
Zapier Experts are certified consultants, freelancers and agencies that can help you do more with automation. They can help you improve processes, recommend applications and streamline your workflow. How to identify a Zapier Certified Expert?Zapier Certified Experts are distinguishable in Community via the Expert badge and title. These identifiers are visible on the Expert’s Community profile page and beside their name within any responses or topics they share in Community: How to get started and what should you ask an Expert you may be interested in hiring?We sat down with Zapier Expert, Andrew Davison of Luhhu to learn more about what to consider and prepare for your first chat. General questions that a client should consider before hiring an Expert or any third-party to assist with their Zaps are: What timezone are they located in? What their working process is (does this align with your own?) How will projects be managed and who will be the main point of contact? Timing is a
I discovered a new feature today (to me anyway) - the ability to export a json file of your zap set-up. To get there click on new info button next to zap title: This will take you to the following page: I remember there was a way to export this json previously but it was not so front-and-center. Now that more people will likely be exporting this file can anybody provide a mapping of the json elements with which apps are used etc? (at the moment the json is all very cryptic). If so, it may be possible to do build a zap feeding this data into a diagramming app like Lucid Charts with a pre-built template and have a cool visual flow diagram of every zap - something I’ve been longing for for ages!
Hi Zapier Community,As stated in the title, I’m looking to get an action to trigger after a year. To be accurate, I set up a learning quiz using LearnDash and I’m looking for a way to send an email a year after it gets successfully completed. Because LearnDash works well with Zapier, it would be convenient to find a way to solve my problem using it.Upon reading the documentation from this article, I understand that a delay can only be scheduled for up to a month in Zapier and I should look for another way to do what I want.However, if someone has an idea on how to bypass this or can recommend an alternative solution I would be grateful to hear it.
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.