Two years ago, our team began building custom software to automate the multi-stage and highly manual team staffing process. Building internal software has allowed the same-size Staffing Operations Team (3 members!) to enjoy a 60x reduction in time spent staffing each role.
The Apps Script ecosystem has emerged as the most critical component in our toolkit for building this internal software, due to its versatility and ease of deployment. We want to share how one piece of the staffing process has evolved to become more powerful over time thanks to Apps Script. Ultimately, we hope that sharing this journey enables all types of teams to build their own tools and unlock new possibilities.
A short script that takes the current value of your portfolio and copies it into a new row while adding a timestamp – thus allowing the chart to visualize the data on a per-day basis.
In this episode of Sheets to Apps, we will show you how to track your work time on projects via Google Calendar. More importantly, he’ll be showing you how you can sync Calendar events to Google Sheets, creating a spreadsheet that shows you the total time spent on your projects.
Gathering inputs from multiple sources and then taking action on each becomes taxing when the task needs to be realized with frequency and with multiple stakeholders. An example is quarterly or annual budget approvals for a finance team.
In this article the author will share how to use an Apps Script in a Google Sheet to automatically create a budget submission form that you can share with end users, and when their responses arrive in the sheet, you can collaborate with other reviewers to send emails in bulk depending on whether you are approving, rejecting, or asking for more information about their request. The emails use a Google doc as a template that pulls information from the sheet such as a user’s name, the budget values they entered, or special comments.
Companies, organizations, households, students, etc all benefit from budget planning in order to optimize savings, because you forecast your total expenses, and then closely monitor the true cost in order to course correct and you reach a savings goal.
In this article the author walks us through how to create our own custom function so we can prepare our annual household budget by entering our expenses in one row and marking their frequency in another (ex: annual, monthly, weekly, daily, or only one time). When we have rows and rows of expenses with different time periods, creating our own formula with a Google Apps Script helps us save a lot of time.
You may be exporting data from an accounting tool into an .XLS format (Excel spreadsheet) every month, and then manually searching, cleaning, and replacing values. More specifically you probably spend a lot of time finding and replacing duplicates, and performing advanced operations such as a VLOOKUP or a QUERY function in order to pull data from other sheets or digging through records that use unfriendly date timestamps.
In this article TechandEco walks us through how to automate this monthly task by using a Google macro and a custom menu, and invite you to try it out yourself. In the future, you can convert your Excel into a Google Sheet by dragging it or uploading it into a folder in your Google Drive>then second click the file to view its options > open as > Google Sheet.
Learn how to scrape data from any subreddit on Reddit including comments, votes, submissions and save the data to Google Sheets
Here’s Google script that will help you download all the user posts from any subreddit on Reddit to a Google Sheet. And because it’s using pushshift.io instead of the official Reddit API, the script will no longer be capped to the first 1000 posts. It will download everything that’s ever posted on a subreddit.
I added a script to Google Sheets that auto added new email addresses to the Google Group every time the sheet was edited.
The author was using Google Group to provide access to their dashboard in Google Data Studio. The members kept adding and the process became tedious. They were already keeping/adding all emails in a Google Sheet for some mapping. So this is what they did.
For a company looking to improve its online presence, the keywords they rank for online, and their position, are crucial. Knowing which keywords to target can be difficult, especially for a smaller business that may not yet rank for many, or established businesses looking to find additional terms they may be overlooking.
One basic tool to hunt for new keywords to rank for is Google autocomplete – the process of simply beginning to type in the Google search box and letting Google suggests possible search terms based on what you’ve input. These suggested terms are based on what other people are searching for using your input term and therefore may provide useful keyword suggestions. This is an introductory blog post on how to utilise the Google Suggest API for keyword suggestions using google apps scripts to pull the data.
