Automate Google Sheets: An Introduction to Google Apps Script

A picture of the Google Sheets logo

Google has built some of the most effective productivity tools on the planet. With Gmail, Hangouts, Chrome, Docs, Sheets, and more, odds are you use Google products for at least some of your work. There’s also a good chance, though, you’re missing out on one of Google’s most powerful tools — Google Apps Scripts. I wrote an intro guide to Apps Scripts putting some of my JavaScript skills to use.

Read the full article on Zapier here.

Make Every Word Count: How to Nail Your Next Presentation

Public speaker on stage

One of my main goals for 2015 was to get up on stage and present somewhere. I ended up achieving that goal at WordCamp Denver 2015 giving a presentation on Hacking Creativity.

I’ve never been particularly shy on stage, but I’m not necessarily a pro either. In preparing for my talk, I uncovered a ton of amazing tips for public speaking. In this article on Zapier, I take readers from idea to on stage with pro tips from the best in the industry.

Read the post on Zapier.

End Internal Emails: How Top Remote Teams Communicate

“Communication is oxygen.”

That portion of the Automattic creed has stuck with me from the start. After reading the creed during my first week of remote work, I had a surface-level understanding. Now, after a year of working with over 250 other individuals spread across the globe, I understand it even more. In many ways, communication is the lifeblood of an organization. Without discussion and collaboration between individuals, little innovation would take place.

It’s easy to emphasize the importance of communication in remote work since employees can’t meet by the proverbial water cooler. But, it’s just as important when employees are working in the same room—launches have to be scheduled, bugs have to be squashed, and relationships must be built.

There are a slew of tools out there for communicating, including Skype, Slack, and HipChat to name a few. However, in some cases, the normal tools just don’t get the job done, leading companies to improvise and create their own systems that work. Let’s take a look at four companies that have cooked up their own communication tool and three takeaways to apply to your organization.

Learn from the best on the Zapier blog.

How to Better Remember and Make Use of What You Read

Have you ever read a book passage that you’re certain could one day be applicable to your life? But, between your shopping list, work to-dos, and your aunt’s upcoming birthday, the passage quickly fades from your memory causing you to draw a blank when you really need to reference it.

When I began reading seriously for personal growth at the end of last year, I experienced this problem constantly. I was flying through books, but I was unable to recall or use any of the information.

Over the past year, I’ve been exploring and testing new methods for organizing what I’m reading for easy retrieval in the future.

Find out more about systems used by Ryan Holiday, Austin Kleon, Maria Popova, and more on the Zapier blog.

10 Content Strategies to Rapidly Build a Larger Audience

Content marketing has exploded in popularity over the last few years with seemingly every business kicking up their own blog or publishing guides and ebooks. In practice, content marketing involves generating valuable content that subtly promotes your brand and attracts an audience, who will hopefully one day become customers. While some businesses have a knack for creating content readers love, others, however, fall short, particularly on content that “attracts an audience.”

What separates the content marketing winners from the losers? I chatted with five top marketers heading up established blogs to find out what helps to set them apart from the rest.

Learn from companies like Buffer and Crew on the Zapier blog.