Questions for automating tasks with little to no human intervention.

learn more… | top users | synonyms

2
votes
1answer
44 views

Is there a way to automatically duplicate 8191 google sheets and name then 1-8191 + copy their urls and add them 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) ...
3
votes
2answers
53 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 ...
1
vote
1answer
1k views

Export CSV from a Google Spreadsheet page from command-line

I'm using a Google Spreadsheet document to configure a data-driven program. The program consumes a CSV file, which now I have to export manually from the document. It is rather inconvenient, as ...
0
votes
0answers
14 views

processing pre-existing data with IFTTT

How can I get IFTTT to process data that was created in the past? If I create a recipe to save liked YouTube videos to Evernote, how can I use it to save all the videos I liked before creating the ...
4
votes
1answer
84 views

How can I get a Google Document to link to the editing of itself?

Imagine a published Google Document. On the bottom I want an "Edit this document" link. Is it possible to do this automatically, somehow? Maybe with a macro or similar? Edit: Just like on a Wiki ...
3
votes
1answer
120 views

Automatically change Gmail signature by recipient

Is there a way to automatically change/adjust the Gmail Signature by the Emails recipient? I'm thinking of adjustable rules or a plugin for the Gmail Webclient. For example: I'm preparing a mail for ...
1
vote
1answer
107 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. ...
5
votes
0answers
2k views

How do I auto-reply to text messages received through Google Voice?

I recently got a new phone number, and I want people who contact me at my old number to be automatically informed of my new number. I've ported my old phone number to Google Voice and set up a ...
0
votes
0answers
20 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 ...
2
votes
0answers
23 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 ...
6
votes
2answers
1k views

Can I set an IFTTT recipe to only run at a specific time?

I'm using a neat little IFTTT recipe that automatically responds to text messages I receive through Google Voice. This one, to be precise. I only need it to run when I'm at work, so I've been turning ...
1
vote
1answer
46 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
34 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
79 views

Fast buy & download list of songs on Google Play

Is there an fast way to buy a bunch of songs from Google Play and download all of them as mp3 files? (A specific list of songs that is, not just any bunch of songs). There are several steps that take ...
1
vote
0answers
19 views

How do I dynamically load all data from an XLS file into Google Sheets?

I have an automated service that places a new, huge (~6MB: ~20,000 rows) .XLS file into my Google Drive every day. I want to write a Google Sheets .gs script that will run once a day, and load all the ...
1
vote
0answers
29 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 ...
2
votes
2answers
919 views

Trello/Zapier: Move card to list automatically on due date

In Trello, I've got a "Hold until Date" list. These cards have due dates, so all of the data exists such that something could programmatically watch the cards in that list until the due date has ...
9
votes
6answers
21k views

Sync Facebook/Twitter posts with Google+

My business uses a Facebook page to post all of their updates on, which (I'm told) are also automatically posted to Twitter. I have just set up a Google+ page for the business, and I would like the ...
2
votes
1answer
57 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 ...
0
votes
1answer
54 views

Move unread Gmail messages to other label

Basically my company uses Gmail to manage all its emails. Emails are assigned to a user using labels. Is it possible that if a message if assigned to a label and is not read that it can be moved to ...
1
vote
0answers
23 views

Play youtube in 2x automatically in Firefox

How can I make videos play automatically in 2x speed in Firefox? I.e. I want 2x to be the default speed when opening av video.
0
votes
0answers
42 views

With IFTTT every 'N'th post on Tumblr, Post on Facebook including top 5 tags used

Currently I have my archive from Pocket being sent to a Tumblr blog via IFTTT. When I review the posts on the blog I reblog them to another Tumblr blog if I like them, with tags. I'd like to post on ...
3
votes
2answers
101 views

How can I get a report of all Trello cards from certain list from several boards

I need to generate a daily report of all cards assigned to me that exist on a specific list in several boards. All my boards have the same structure so the naming of the lists is always the same. The ...
0
votes
1answer
54 views

How can I archive multiple articles on Instapaper at once?

Instapaper is useful for automatically sending articles to my Kindle. However, once they're sent they still remain in my reading list, unarchived. I'm looking for a way to automatically archive them, ...
0
votes
1answer
164 views

Post another person's tweets into Facebook group?

How can I re-tweet another person's posts into my Facebook group? I am interested on doing this automatically, since I basically want to re-tweet of all this person's tweets.
2
votes
1answer
98 views

Automatically save Facebook photos where I have been tagged

I would like to automatically capture any photos post on Facebook in which I am tagged. For instance, a friend posts some photos from a get-together and I'm tagged in some. I'd like to be able to grab ...
1
vote
1answer
149 views

Triggering timestamp on formula input

I'd like to have a timestamp which triggers its input depending on a cell containing a formula like =IF(ISBLANK(cell),"", time ), and not upon manual input. My script is the following and is working ...
1
vote
1answer
155 views

Can I have a custom button in Gmail UI so current message will be autoreplied with canned response and archived then next one displayed?

I keep receiving hundreds of emails which I usually reply with the same Canned Response. It takes dosen of clicks per each email. Can I have a custom button in Gmail UI so current message will be ...
5
votes
1answer
50 views

Is it possible to sync questions and answers that I post in all of Stack Exchange site to Twitter?

How can sync I my Twitter and Stack Exchange accounts together so that the questions and answers that I post to all of Stack Exchange sites are auto tweeted to my Twitter?
1
vote
0answers
345 views

Gmail Auto-Response, one time only

I want to set up auto-reply emails using scripts. We're currently using Canned Responses but the emails we're responding to just changed their setup so instead of sending the reply to the sender, we ...
1
vote
1answer
72 views

Is there a way to mark all mail as read at the end of every day?

Is there a way to automatically mark all the emails in my Gmail inbox as read at the end of every day? Even better, if it didn't mark the email in the 'Primary' tab read. Note: I am looking for an ...
3
votes
1answer
424 views

How can I create a Google Spreadsheet whose name and cells auto-complete with cells completed on another sheet?

I'm using Google Spreadsheets to manage projects, and I'm not familiar with scripts or macros (though I'd really like to learn how to use it, so if you have any good tutorials or tips, let me know). ...
0
votes
4answers
21k views

How can I set Gmail to auto respond to all emails?

I've created a canned response. How can I use the filtration system for auto response in Gmail to reply to ALL incoming? Granted, I would only care for the auto response to be sent only to humans. I ...
0
votes
2answers
198 views

Other than tabbing all the way through it, what is the quickest way to fill out this web-based time input form?

In the form below, the tab index does what you think it does. I have been entering this form the same way for years by tabbing through it, but I have a hunch there is a macro/script out there that ...
-1
votes
1answer
717 views

Automated web form submission and retrieval

My ISP has a web form I can check to see what my current bandwidth usage and quota is. It's drudge work to everyday load that page, enter MAC address, submit, wait for results, scroll down to read ...
2
votes
0answers
440 views

How to automatically reblog your Tumblr liked posts

Is there a way to automatically reblog1 the posts you like on Tumblr? I looked into IFTTT but couldn't find the right hooks. 1. On a different Tumblr, not the default one.
6
votes
1answer
360 views

Can I configure GitHub to trigger an email, twitter, or other event when a new release is published?

I would like to send notifications to a specific set of users when a new version of our software is released. People who 'watch' the repository get notifications for releases from GitHub, but I would ...
1
vote
0answers
66 views

Is it possible to automatically schedule old Tumblr posts to appear on Twitter?

I've got a large Tumblr archive and would like to tweet one post every few days to Twitter. Is there any way of doing this automatically?
1
vote
1answer
306 views

How to autoshare scheduled YouTube uploads on Facebook

On my YouTube account, I use scheduling of uploads a lot. The problem is when I do this IFTTT won't "see" my uploads. The only thing that it looks for is when you upload something publicly, and not ...
4
votes
0answers
166 views

Is there a way to add new GitHub repositories automatically to a team?

Say I have an organization on GitHub called ORG and a team comprising of all members in the org called TEAM_ORG. I would like any number of repositories that I ever create under the ORG GitHub ...
0
votes
1answer
356 views

How can I set up auto-reply for each email from the same sender?

I am trying to set auto generated reply in Gmail using the vacation responder. But it will send the email after 4 days if same person sends another email. I want to send reply for each email if same ...
9
votes
1answer
3k views

Auto CC all outgoing mail [duplicate]

Is there a way to auto CC to a specific email adress all outgoing emails from a Gmail account? I tried doing it with a filter but I don't have the option of CC. I know there is a script for ...
7
votes
2answers
5k views

Google Docs keeps reverting to Arial 11pt

I use Google Docs for typing up a lot of work, and I like to type it up in Garamond. However when I add line-breaks sometimes Google Docs decides to revert to Arial 11pt (the default style for a new ...
0
votes
1answer
343 views

Auto-forwarding messages on a Facebook group to a mailing list

A group I'm a member of has people who use email only, Facebook only, and both email and Facebook. I would like to enable to the email-only people to read messages that people post on the group's ...
2
votes
0answers
359 views

Email Count in Zimbra

In our office we use Zimbra and we have a little administrative problem. Every Monday our secretary has to manually create an email in which the number of emails is shown for every user. She has to ...
2
votes
0answers
383 views

IFTTT: Can I do two actions separated by a delay of 30 minutes?

I would like to use IFTTT to turn on an outside light when triggered and then, automatically, after 30 minutes, turn off the light. The trigger would be an SMS message and the switch is a Belkin WeMo ...
2
votes
3answers
9k views

Automatically send emails from Gmail

I use Google Apps email to send out details of a product I sell to people who enquire about it via a web form. After a month or so I go through my Sent Mail folder and send a follow up email to all ...
0
votes
1answer
184 views

How to unlist automation friend lists in Facebook?

In my Facerbook friend list, there are some lists that were created automatically (the one with lightning icon on their right) e.g. the lists whose names are my high school and undergraduate ...
2
votes
2answers
352 views

Automatically creating events related to a new event in Google Calendar

Does anyone know of an existing tool that will let you automatically create multiple events whenever a new event is added to a Google Calendar? The use case is if you always have the same pre/post ...
0
votes
0answers
686 views

How do I automatically add new YouTube music to a playlist?

I am subscribed to various YouTube channels that release new music on a daily basis. Many of these channels unfortunately do not have a SoundCloud. As of now, I manually scroll through my ...