Questions tagged [automation]
For questions about automating a web application task.
1
vote
2answers
17 views
Given a shared Dropbox link to an Excel file, how can I easily open it in Google Sheets?
Scenario:
I get an email every two weeks with a vendor's price list as a link to an Excel file in their Dropbox.
At this point, I have to:
open the link — This takes me to Dropbox, where the file ...
0
votes
2answers
48 views
Can I auto populate cells in Google Sheets?
I have a bunch of categories; Bar Foo Ghost Misc Other
All have variable amounts - except for category Ghost, the amount is always 15.00.
I have Data Validation set up (which is how I pick the ...
0
votes
0answers
130 views
How to programmatically create/download Google Takeout archive?
I want to automate the process of downloading my Google Takeout data and uploading it somewhere else. The part of handling the file and uploading it is already done (here is my self answer about that)....
3
votes
0answers
46 views
Automatically turn on Gmail Vacation Responder from gCal 'Out of Office' events
I see some good scripts on turning on responder for 'every Friday', etc., but with the new gCal feature of 'Out of Office' events, is there a way to turn on vacation responder any time there is ...
0
votes
1answer
23 views
Copy data to new column in Google Sheets
I have a sheet with IMPORTHTML that I want to copy data from one column to a new column daily.
function saveData() {
var spreadsheet = SpreadsheetApp.getActive();
spreadsheet....
0
votes
0answers
6 views
Trello automatic notification
I have a simple need on my Trello boards: schedule a card (with some properties like labels or checklists maybe) that must notify the board.
Until now I am manually adding a card and a comment with @...
1
vote
1answer
37 views
Get a SMS or Push Notification instantly when an email is send to Gmail
I have integrated my business email to be checked via my Gmail account, using the "Check email from other accounts:" option using POP3.
I want to get an instant SMS or push notification on my Android ...
0
votes
0answers
24 views
XPath to a div with dynamic id on Facebook
I have created a simple iMacros automation flow to get the embed code for each given Facebook post ID.
I used XPath to find the menue button on the top right of the post and then automatically click ...
0
votes
1answer
283 views
Google Sheets - Importrange
Currently we have one summary sheet called Order_Summary which collects data, one day per column and someone at work creates a new column daily. We now have another google sheet which now records an ...
0
votes
0answers
32 views
How to automate Gmail response, different first and second response?
I am seeking help to automate the Gmail response to new community members in an apartment complex.
First, new members send/email us a new membership, including name, i.e. request as a new ...
0
votes
1answer
71 views
Automatically switch to another Google account during work hours?
I have two Google accounts:
personal@gmail.com
business@company.com
Is it possible to automatically change between during working hours?
Example:
Monday to Friday
08:00 - 17:00 -> business@...
2
votes
1answer
298 views
Automatically save a mail from Gmail to Google Drive
Every month I get approx 50 receipts for various things via email. I need to copy/print these to pdf (or similar) and store them in a receipt folder (eg. July 2018) on Google Drive. Currently, I do ...
2
votes
1answer
33 views
Search prices for a list of items
I have a list of supported Router models for the gluon Freifunk firmware. and would like to create an automated list, that always shows the actual prices for those routers.
How is it possible to ...
0
votes
0answers
12 views
Can you convert campaign types in MailChimp
Someone created an automation for me, but used the Regular (HTML) campaign type.
I want to keep the automation, but convert the campaign to plain text.
Is this even possible?
0
votes
0answers
30 views
Google Sheets onEdit automation and separating strings in a cell
I'm compiling a google sheet with a list of Form Responses after answering questions on a google form. This is what the google From Response Page would look like:
I want to compile a script so that ...
1
vote
0answers
13 views
Want to integrate template responses (from Sheets) into other apps
I teach online classes and have to create feedback for every class. In a Google Sheet, I have template responses for each class (labeled by level, unit, learning cycle, class (L1-U1-LC2-7 for example))...
4
votes
1answer
254 views
Set an expiration date for e-mails (auto delete after date)
Certain e-mails stop being useful after a certain date, for example: Uber discount codes that I might use, invitations to events that I might attend, etc.
Is there a way to set an expiration date for ...
3
votes
1answer
306 views
How to set Git branch protected in GitHub by default when create it
I need to make a branch protected directly when creating it. I know that I need to go to Settings and set it as protected from there, but what I'm looking for is to set the branch as protected ...
1
vote
1answer
363 views
How to automatically post a Google Form response to a Google Group?
I created a Google form where I collect some information from users concerning a project and the last question I ask is: "Write your questions about this project?"
What I would like is that the ...
1
vote
1answer
813 views
Is there any way to “set yourself to away” in Slack automatically?
I already checked this link and try IFTTT and Zapier, but they only let me post messages to the channels. What I want to do is perform the same action that the comand /away does at a given hour, and ...
0
votes
1answer
894 views
How to make custom auto-replies in Skype for specific group?
I have a chat-group with my colleagues concerning the server and services restart occurrences and what I want to achieve is when my Skype is under specific status (Away, Offline) to automatically ...
3
votes
0answers
297 views
Gmail auto Canned Response sends to wrong address
I have a small irritating problem which is that I'm often being confused with some other guy with the exact same name who lives on the other side of Sweden. Which means that I receive quite a lot of ...
2
votes
0answers
334 views
Auto reply in Gmail, when using Gmail for several domains/addresses
I'm using the "Send mail as" (Use Gmail to send from your other email addresses) feature to send from my unique Gmail account interface, all the mails for:
myname@gmail.com
contact@example1.com
...
-1
votes
1answer
27 views
VSTS deploy to third party hosting?
I'm using VSTS for some source control and was wodnering if it was possible to setup the build & deploy feature to deploy a basic html site to another hosting company other than azure.
Any ...
3
votes
2answers
40 views
Mailchimp automation - Leaving a group
I am busy setting up an automation workflow when someone joins a mailchimp group within a list. There are multiple groups within the list, and there are several emails that will be sent to them over ...
1
vote
2answers
49 views
How do I replace a sequence of placeholder images in Google Docs?
I have a Google Doc document featuring a series of placeholder images. I need to replace each image with a series of images from a local folder. In theory, this is a meaningless task, but so far, my ...
1
vote
1answer
49 views
Automatic Facebook post from Twitter list
Is it possible to automatically post other peoples' posts on my Facebook? If so how do I do it?
I am trying to create a page which takes information from Twitter and posts it automatically.
4
votes
2answers
803 views
Automatically post to Instagram from Twitter / Facebook / Tumblr post?
I have a blog and various social media channels to which I regularly post a curated set of images. I'd like to automatically post to Instagram. My current multi-platform social media setup is like ...
2
votes
0answers
144 views
Is it possible to start Google Photos slideshow automatically?
I know I can start a slideshow for my Google Photos album by going to menu options and selecting Slideshow.
Is it possible to share an album on Google+ so, when a user clicks on it, the slideshow ...
2
votes
0answers
38 views
Recurring signature block in Google Docs
I need to often input a signature block in documents made in Google Docs. This particular signature block has a line for an official's signature, with his title immediately under that line.
In Word, ...
1
vote
1answer
58 views
Is there a way to automate texting based on a group a contact is added to in Google Contacts
I'm wondering if there's a way to send a generic pre-written message to any/every contact that's added to a Google contact group.
0
votes
1answer
513 views
Automatically send email with PDF of sheets weekly
Is it possible to automatically send weekly emails to a list of recipients of PDFs of each sheet in Google Spreadsheet? I've looked around but haven't found any ways to do this, only found ways to ...
1
vote
1answer
861 views
How do I use Gmail's Vacation Responder or Canned Responses feature to respond to the From instead of the Return-Path address?
As described in this question.
Both the Vacation Responder and using a filter to send a Canned Response send the response the Return-Path field of the email, not the From field. Please don't tell me ...
1
vote
1answer
186 views
Is it possible to create a trigger on a delay using IFTTT?
I have these files on my clould's storage, and I want to create a rule that will share them with say N people (mailing them, or using one of the social networks).
Yet I want to delay this sharing ...
1
vote
1answer
40 views
Automation Google Presentations
I have charts in Google Presentations linked to Google Spreadsheets data, but every time I have to click the update button. It is possible some kind of schedule so the chart can update automatically?
2
votes
3answers
609 views
Can you automate placing emails in folders in Office 365's Outlook?
I use Office for work. Frequently, I will get a massive amount of work emails in my mailbox.
A regular Monday morning. This includes 0 unwanted emails, only work.
I would love to know if there is a ...
1
vote
0answers
31 views
Autoresponder in Gmail for one particular address (TO this address, not FROM)
I use Gmail to work with my external POP3 accounts as well. I want to use one of them just as an autoresponding address (because I stopped working for this company but still receive emails which I don'...
0
votes
0answers
277 views
How to stop Google Apps Script responding to noreply
I have a script that I have adapted to suit my needs.
function autoReply() {
var interval = 5; // if the script runs every 5 minutes; change otherwise
var wkend = [6,0]; // 1=Mo, 2=Tu, 3=We,...
2
votes
1answer
1k views
Any way to send Gmail Out of Office/Auto-reply at the same times every week?
Because my clients bother me out of hours I would like to have my Out of Office respond out of hours without having to set it manually every day.
To comlicate matters further I want to send one ...
2
votes
1answer
744 views
Is there a way to automatically duplicate a large number of Google Sheets, name them, then copy their URLs to another sheet?
Background:
For a genealogy project, I've created a Google sheet where participants enter all details of one ancestor. (FILEXXXX)
In another Google sheet (not just another tab/sheet, another FILE) ...
2
votes
1answer
4k views
How can one auto create pre-filled URLs with registered addresses from a roster
We use google forms to send out tests to our students. We have a spreadsheet with rosters where we keep the info of the students (email, birthday, gender, guardian etc) for every class in our school. ...
1
vote
1answer
72 views
Are there any ways to get an email address subscribed to one list twice?
Mailchimp's practice of restricting each email address to only appear on each list once is normally (99.99% of the time) very sensible. As a seasoned Mailchimp user, I'm keenly aware of the benefits ...
3
votes
0answers
116 views
How can I automate reporting spam on Google groups?
I'm a member of a particular Google group such as: math. I want to automate the process of clicking on a messsage, either from a certain user or having a subject line such as "books", and then ...
9
votes
2answers
12k views
Any way to send Gmail auto-response at certain times every week?
I have a Gmail account that it is only monitored Monday through Thursday. I would like to set something up to automatically send a canned reply for emails received between Thursday afternoon and ...
3
votes
2answers
234 views
Having trouble getting rating sheet to update as games are entered
I keep a spreadsheet that uses the elo equation for chess where I work that updates players ratings when I enter the two players names and who won or lost (1 for win, 0 for loss). My issue is that it ...
4
votes
1answer
1k views
IMPORTHTML at a certain time of day in Google Spreadsheets
I am looking for a way to import the table from this formula once per day at a certain time instead of automatically updating as the formulas seems to do. I need to do this in order to track certain ...
3
votes
1answer
2k views
How should I automate graph generation and image output in Google Sheets?
I am trying to send graphs of data to email recipients.
I would like to output images of row-specific graphs based on cells in a Google Sheets document. In combination with Google Sheets/Drive, I am ...
1
vote
0answers
290 views
Syncing Google Docs with Microsoft Onenote?
Does anyone know a way to sync Google Docs with Microsoft Onenote? If syncing is not possible, then even triggering a backup would be nice. I know that IFTTT and Zapier can copy from Evernote, but I ...
1
vote
0answers
65 views
Automate the archiving of Evernote notes on archive.is?
I have a shared Evernote notebook which I use to collect news articles for a project that I'm working on. A couple of times a week I work through the notebook and run the webpages that new notes are ...
3
votes
1answer
123 views
Automatically add photos shared with me to Google Photos
I use Google Photos for all photos I take. When we have an event, friends and I tend to share photos to each other, using Google+. I can see the photos fine - but I really want a way of making them ...
