Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [automation]

For questions about automating a web application task.

Filter by
Sorted by
Tagged with
0 votes
2 answers
29 views

Automatically copying the formula whenever I INSERT rows IN BETWEEN rows, not at the end of the row

What I want to happen is that whenever someone insert a new row in between rows, the formula would have also copied there instead of dragging the column again and again. Here's the code that we're ...
Zen_Zen_Desu's user avatar
0 votes
0 answers
21 views

How to create a Todoist task from a Telegram message and link each other by URL

Normally we work by creating topics on Telegram groups. Quite often we want to create a task after a discussion or decision in Todoist. Then we link the latest Telegram message to the Todoist. We do ...
chelder's user avatar
  • 371
1 vote
1 answer
27 views

Editing the second line in all cells

I am creating a sheet in which the first column has two lines of text in every row. How can I bold the second line only in all cells without doing it manually as I already created the sheet.
Jaclyn's user avatar
  • 11
1 vote
0 answers
26 views

Print out a governmental form that spans over few webforms [closed]

I would like to print an online filled forms such as form 5669 (and few other, smaller forms) at Immigration Canada permanent resident portal . It can help validate them, form 5669, for instance ...
Serge's user avatar
  • 117
0 votes
1 answer
22 views

Create Google Calendar event 15 minutes before start of existing Google Calendar event

I'd like to create a new event in Calendar2 15 minutes before an event begins in Calendar1. No errors occur, but the applet does not create an event in Calendar2. Seems like a no brainer but I can't ...
Scottmeup's user avatar
  • 131
-1 votes
2 answers
53 views

Google Apps Script for gradebook sharing: Create duplicates of current sheet, one per row of data, with importrange of the source and header rows

The goal is to create a workaround to the typical problem of not having per-row privileges. I want students to only see their row of the grading document. Typical solution is to share another sheet ...
whatsnewsisyphus's user avatar
2 votes
0 answers
308 views

Automatically post/share to group as a page/from a page

Is there any way to automatically share posts from your own Facebook page to your own Facebook group, with the post showing that it came from the page? I tried several automation tools, but the only ...
user80928's user avatar
5 votes
2 answers
8k views

How to translate images with Google Translate in bulk?

My workflow for a single image: I go to https://translate.google.com/, click the "Images" button, click "Browse your computer" to choose an image, translate, download the ...
akratz's user avatar
  • 263
-1 votes
2 answers
82 views

Subtotal of duplicate items in cell mentioning the duplicate items the last time

Currently, I am using the sum function to total matching item names by manually selecting matching cells. I would appreciate help automating the calculation of subtotals by item name. Link to my ...
Rohit Kumar's user avatar
0 votes
1 answer
152 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 ...
Kuba Mikołajczyk's user avatar
0 votes
0 answers
39 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?
BestR's user avatar
  • 109
0 votes
1 answer
316 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 ...
Dan's user avatar
  • 35
0 votes
1 answer
48 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 ...
Louis B.'s user avatar
  • 123
1 vote
0 answers
33 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 ...
Stefan's user avatar
  • 11
1 vote
0 answers
22 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 ...
Jacob Trader's user avatar
0 votes
1 answer
459 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 ...
High GPA's user avatar
  • 103
1 vote
0 answers
49 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 ...
Doc's user avatar
  • 11
1 vote
1 answer
79 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 ...
pfnanc's user avatar
  • 43
1 vote
1 answer
36 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&...
NKlaus's user avatar
  • 19
2 votes
0 answers
209 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 ...
Demento's user avatar
  • 161
2 votes
1 answer
1k 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 ...
StackBuck's user avatar
  • 123
3 votes
1 answer
349 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 ...
Sebastian Arthofer's user avatar
0 votes
1 answer
253 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 ...
Adriano's user avatar
  • 111
1 vote
1 answer
1k 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 ...
user avatar
3 votes
1 answer
13k 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 ...
Sahab's user avatar
  • 53
-1 votes
1 answer
79 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
Nam Ngo Hoang's user avatar
1 vote
1 answer
337 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 ...
Dewi's user avatar
  • 11
1 vote
1 answer
91 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 ...
Teresa Condon's user avatar
3 votes
1 answer
249 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 ...
Driveuser's user avatar
0 votes
3 answers
268 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 ...
llevar's user avatar
  • 121
1 vote
0 answers
254 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. ...
Cynthia Tan's user avatar
1 vote
3 answers
792 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 ...
Sherwood Botsford's user avatar
0 votes
2 answers
9k 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 ...
Welz's user avatar
  • 218
13 votes
1 answer
14k 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)....
Fabian Röling's user avatar
4 votes
0 answers
535 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 ...
Tony Pederson's user avatar
0 votes
1 answer
82 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....
akiva's user avatar
  • 103
1 vote
1 answer
139 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 ...
sigur7's user avatar
  • 113
0 votes
1 answer
881 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 ...
Darth Silva's user avatar
1 vote
1 answer
200 views

Automatically switch to another Google account during work hours?

I have two Google accounts: [email protected] [email protected] Is it possible to automatically change between during working hours? Example: Monday to Friday 08:00 - 17:00 -> business@...
Lucas Bustamante's user avatar
3 votes
1 answer
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 ...
user avatar
2 votes
1 answer
99 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 ...
rubo77's user avatar
  • 497
5 votes
1 answer
825 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 ...
user avatar
3 votes
1 answer
812 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 ...
user's user avatar
  • 33
1 vote
1 answer
3k 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 ...
Mireille's user avatar
4 votes
1 answer
5k 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 ...
Kenny Barrera's user avatar
1 vote
1 answer
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 ...
tsoliaspn's user avatar
  • 194
3 votes
0 answers
770 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 ...
AndroidHustle's user avatar
3 votes
0 answers
743 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: [email protected] [email protected] ...
Basj's user avatar
  • 576
-1 votes
1 answer
37 views

VSTS deploy to third party hosting? [closed]

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 ...
Webezine's user avatar
  • 101
3 votes
2 answers
88 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 ...
darkpool's user avatar
  • 133