Questions tagged [automation]
For questions about automating a web application task.
128
questions
0
votes
0answers
8 views
specific recurring date, if x then x
hi i was wondering on google calendar or really if there is another calendar that does this if it was possible with like a code or something that you could make a recurring date. Like for example, ...
0
votes
1answer
9 views
Prevent manually added data from shifting rows in auto-updating google sheet
Link to test file
In my test file, I have two sheets.
1.
^ First one represent automatic data which will be later on fetched from auto-updating place like salesforce.
2.
^Second one has automatic ...
0
votes
0answers
14 views
Conditional content in column A based on value in column B, with content determined by column C
I am trying to automate a task where the contents of one column is informed by the (text) value in another column. The content should be pulled from a list in the spreadsheet.
For example:
In this ...
0
votes
0answers
17 views
Disable received emails in confidential mode
In Gmail, there are contacts of myn sending to me emails in confidential mode, which make it harder for me to manage in automation.
Is there an option to make all emails I recieve as unconfidential?
0
votes
1answer
92 views
Track highest and lowest number reached in a specific cell over a period of time in google sheets
I have a cell that references the total value of a stock portfolio. I want to figure out how I can let Google Sheets (over a period of time, say a month) automatically tell me the highest number and ...
0
votes
0answers
11 views
How to automate Enumeration and Cross referencing Exhibits
Given a series of three photos: Alpha, Gamma, Delta. and they are enumerated in two sentences:
Exhibit 1 is a photo of an Alpha specimen, where as Exhibit 2 is a
Gamma specimen. Recently a new ...
0
votes
1answer
20 views
Automatically add a calendar entry
We are using Office 365 / Outlook calendar to keep track of customer appointments.
We have certain forms on our website for customers to request an appointment. After such a form is submitted, a ...
0
votes
0answers
6 views
Auto sequential number generation
I am using Trello for customer order management, using each list as a project stage, using a card template for a standard customer project - each card is a customer project
Is there a way of ...
0
votes
0answers
12 views
Limit Add a Card to one list
I am using Trello for customer order management, using each list as a project stage, using a card template for a standard customer project - each card is a customer project
Is there a way of limiting ...
0
votes
0answers
35 views
How to automatically create a public link from OneDrive?
I m using Office 365 E3.
I know such thing can done from the web Interface, but in my case there are 100000 files in the folder I want to share.
I also can t share that whole folder, since I want only ...
1
vote
0answers
27 views
Pull data from separate Google Sheet into a Google Forms response sheet and update dynamically
I have a Google Sheets leave sheet for employees where we track the leave days due and days already used. I also have a Google Form which submits responses to linked sheet and runs with Form Publisher ...
0
votes
0answers
8 views
Insert dynamically first nam and last name in google document [duplicate]
Is there a way to insert user elements (like name) dynamically in a Google Document
For example, I have some GDocs templates and I want to use variables in the footer. This variables insert the name ...
1
vote
0answers
19 views
Change the text string of a cell based on whether or not previous cells are filled
I am working on a spreadsheet that tracks the overall pipeline for video production for a group of volunteer filmers and editors. Being on as a volunteer manager myself, I wanted to create a ...
0
votes
1answer
74 views
How to repeatedly perform Google search without being asked for human verification?
Suppose that you want to perform repeated Google search through automation, then, once every 20-30 searches, google might ask you for human verification, which is very hard for a non-human agent to ...
1
vote
0answers
40 views
How to auto reply to email in GMAIL
I've managed to successfully auto reply to emails via the Gmail canned responses and using filters.
However, my use case is that I want to auto reply to some emails where the sender is me (the from ...
0
votes
0answers
32 views
What web apps are available to dynamically forward email according to a schedule?
With increased remote working due to the pandemic, I'm looking for a better way of managing our support rota.
My use case is that we have people scheduled to take 3-hour shifts looking after an inbox. ...
1
vote
1answer
46 views
Is there a formula to automatically populate invoice with only the products that have been ordered and excludes the products not ordered?
I have a range of products in my order data sheet and I need help creating a formula that automatically fills up my Invoice sheet with only the products that were ordered.
Currently I can only ...
0
votes
1answer
22 views
Get exactly data to put on email message?
I got a function to email notice like this code below:
function approvedby() {
var approvedrange = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Responses 1").getRange("E2:E500");
var ...
1
vote
0answers
10 views
How to automatically add data series to line chart when new row of data added to underlying sheet?
I have a line chart where the X-axis is Day of Week and Y-axis is a count. The underlying sheet has Sunday dates in column A, where each row is one week apart, and columns B-H have count values for ...
2
votes
0answers
105 views
How to create an auto-reply to unknown senders in gmail?
I want to send automated replies to emails I receive on my gmail account, if I haven't corresponded with the sender before. This basically mimics an out-of-office / vacation reply, but only triggers ...
1
vote
0answers
17 views
How do I auto timestamp a sheet when something is moved to it
I am using this function to automatically move a row to a secondary sheet when a set value is entered.
function onEdit() {
var sheetNameToWatch = "Tracker";
var columnNumberToWatch = 4;
var ...
1
vote
1answer
370 views
How to Automatic Reply to Sender if email contains certain words?
We have G Suite (Gmail) email, and we have the same question every day. We thought about Automatic Replies to emails that came with certain words.
We are looking for an (even paid) service (which is ...
2
votes
2answers
214 views
Show/hide fields (if empty --> don't show)
we are working on a project to atomize our offer process. We have multiple insurance products which can be chosen and are then passed on through zapier to Google Docs. Obviously not every customer ...
0
votes
1answer
46 views
How do I download all photos in bulk from Facebook
What I would like to do is to download all the pictures:
I have uploaded
I am tagged in
The way offered by Facebook itself seems to allow only to download pictures in low resolution format (this ...
1
vote
1answer
352 views
How can i get alert when a new post get added to an Instagram profile?
because Instagram doesn't have the bell option ..
i don't if it's possible using (js or vbs ) .. if there isn't a way to do this without letting my pc turned on the whole day ...
i do need to make ...
1
vote
1answer
6k views
How to move Gmail labels from one account to another
Is there any way to transfer all the Gmail labels from one account to another.
Importing filters are easily possible by exporting and importing. Importing filters also creates the labels they are ...
-1
votes
1answer
62 views
How to automatically add new row in Google Spreadsheets
I want to automatically add row in Google Spreadsheets when I type information in row 5 by Google script.
]1
1
vote
1answer
69 views
Auto-increment where cell values not NULL
I have a list of items purchased, like below.
A | B | C | D | E |
id | item | qty | unit price | subtotal |
I'd like to have the column id to ...
1
vote
1answer
68 views
How to automatically send replies to Gmail (from a certain address) during business hours?
My landlord has requested that I only send him or respond to emails during business hours. Is there a Google script that would automatically draft my response and send it to him during the next ...
3
votes
1answer
139 views
Does Google Drive 'Contributor' Permission allow malicious users to permanently delete file contents?
In my attempts to use Google Drive for some automated important data backups, I'm making use of the API and a Service Account to upload data to a Team Drive. The account only has 'Contributor' access ...
0
votes
3answers
243 views
Migrating from flickr to google photos
With flickr putting the kibosh on unlimited photos with the free account I'm wondering if there is a known automated way to migrate thousands of photos from my flickr account to google photos. I've ...
1
vote
0answers
129 views
Can Google Form send email automatically based on entered field?
I would like to use Google Form as a help desk, hoping to find a script that can send email of the submitted form responses to different people depending on their option in one of the question?
i.e. ...
1
vote
3answers
513 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
8k 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 ...
7
votes
1answer
9k 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)....
4
votes
0answers
392 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
51 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....
1
vote
1answer
74 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
1answer
820 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 ...
1
vote
1answer
115 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@...
3
votes
1answer
1k 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
78 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 ...
4
votes
1answer
630 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
726 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
2k 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 ...
3
votes
1answer
4k 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 ...
1
vote
1answer
4k 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
572 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 ...
3
votes
0answers
650 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
34 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 ...