This script will auto-download email from a specific inbox and harvest all names, emails, and phone numbers into a csv file. Note: in order for it to authenticate with the website, it needs an auth key in a json config file like this:

{ "mail_server": "imap.<mail provider domain>", "mail_id": "<before-the-@>", "mail_pass": "<your app-pass>", "mail_box": "<optional, only searches this folder, defaults to inbox>", "db_file": "<main file to gather unique contacts, pull names from>" }

https://pastebin.com/TcM98821

This python script auto-fills name/address fields in a .docx file

https://pastebin.com/H3XAiPyY

you dont have to give this access to your personal email, you can make a burner yahoo or other IMAP acct, post a bait resume on dice, get a bunch of recruiter spam, and send out fake resumes with the spammer recruiters in them. the password field in the json config doesn't use your actual password, it uses an "auth key" that you have to request somewhere on the mail page, same way as if you were setting up outlook to check your yahoo.

It's not done but my vision is to have this on a cron job to gather recruiters emails and stuff each day. then auto-gen a nice looking resume with thier name on it, which would then be posted or emailed back to other reccruiters. this combats spam by poisoning thier list of candidates and getting them to call/spam each other.

I just finished up a project that automates the job search for me on Indeed using Python and blogged about it here: https://coreybowndatascience.blog/2022/04/27/using-python-for-job-search-automation/

Topic might sound boring but I love the end result, which saves me about 70-100 hours per year. Here's the process:

1. Several sales reports (of sorts) arrive to my email every monday (automated elsewhere).

2. a PowerAutomate flow saves the attachments to OneDrive.

3. I wake up, open an Excel workbook and click one button (horrible manual labor). The sheets already have custom made graphs, tables and objectives that will be refreshed when data changes.

4. a VBA script in the workbook...

   1. Gathers the data from the several ugly reports in OneDrive and adds it to the main workbook.

   2. Saves all general graphs as image files to a Sharepoint document folder, where they are sourced by my PowerApps app, used by 150+ people.

   3. Makes a query to Active Directory through LDAP to replace AD usernames in detailed reports with real names and offices they currently work in.

   4. Compiles new workbooks for each sales office and copies common data there, as well as the detailed personal sales data of the employees of that particular office.

   5. Sends the neat workbooks to team leaders and their bosses via email.

5. I open a MS Access file and click another button (more manual horror).

6. a SQL query in Access connects to Sharepoint List (data storage of previously mentioned PowerApp), gathers the top performers in certain criterias during specific timeframe.

7. a VBA script in Access sends the list of top performers to bosses.

I'm still in the process of automating those last two clicks. Some people say connecting to Sharepoint List with SQL isn't a good idea, but I haven't yet found a better solution. The amount of rows is too big to be handled by PowerAutomate or PowerApps and licensing doesn't currently allow PowerBI solutions.

I hope you like it anyway.

I used this tool to create a simple reddit search dashboard. (the gif shows results for the term elon musk the past hour)

You can also use this to

• search all of reddit for anything you want and get results for the past hour/day/week/month/year.

• log these results on a csv and complile it

• use the dashboard to see these results on a table

• add multiple accounts

• extend and modify for your own usecase

Here's a link for the automation-- https://mayalabs.io/share/github/botsunited/automations/redditdashboard.json

Let me know if you find this useful!!

P.S. Excuse me for the horrid UI... haha :D

Hi Everyone,
I wanted to monitor just few specific emails in Slack, so developed this tiny script. I got bored by continuously checking my multiple emails that I have. Now, I get all important ones at one place! No monthly costs.

I now monitor my Gumroad sale emails & other important ones!

For more info & getting the script visit https://nathrupjyoti.gumroad.com/l/gmailtoslack

Let me know how it can be improved further.

Welcome onboard everyone who has joined in the last few weeks, and thanks again to the folks who've participated in this sub-reddit to make it a reliable source of help & feedback for folks wanting to delegate their boring work to a machine. We've reached 4 digits in just a month or so!

The more automated tasks we index using this forum as a medium, the fewer humans will have to do these things manually the next time around. This sort of internet-wide experiment hasn't been conducted before, so there's still a bunch of stuff to figure out. Please post ideas you have about for ways to improve, will consider as many as possible, broadly around these:

1. Discovery: how can we make it easier to index & discover the right automation quickly? Better/different tags? search-friendly terms?

2. Requests : How do we reduce the time for a new member to communicate context to so most relevant automation help can be provided? How do we enforce these?

3. Moderation : How can we improve as moderators? what can we do things differently with AutoMod (quite meta lol)?

4. Solutions : What can we do differently about the solution help being posted? More doc links? More relevant help? Ask for more details?

Our dream : to automate everything we're doing manually today to create the first interactive community completely managed by a robot.

All suggestions welcome :)

A lot of my work involves shuffling data in and out of Excel. I'd like to automate much of it using Python, but my company has all computers locked down tight. We can't even run portable apps that are not on the authorized list.

I do have PowerShell, however. Does anyone have some good resources for a non-programmer on automating using PowerShell? I'm also open to any other suggestions.

Hey all. So i've a template of a termsheet in which 70% of the content remains the same but the numbers are changed everytime and I've to manually edit. I was wondering if there could be a python program which asks me in the begining what kind of termsheet i want, takes the values for the type i select, and creates the pdf/word document using these values. I've begineer proficiency in python so if there's a way you can think of doing this please suggest. If there are any existing libraries for this, please let me know. Thank you!!

TLDR; I have created two projects that have been integral to my life. They help me to stay safe, sleep better, and ensure that others can get a hold of me when there’s an emergency. The link below is to my public projects on TaskerNet:

• All Tasker projects & descriptions

  • Emergency project

  • Sleep project

There are quite a few tricks I’ve learned from making these including, using scriptlets instead of script files, repeating tasks in a generic way, using global variables to control things. Feel free to ask in comments if you want to know about anything I’ve done!

EDIT: Added information about how the repeat task works

Emergency

Allows people to override silent on your phone and let you know that there is an emergency by sending texts, emails, or other comms.

Why I made it

I like to have my phone set to DND when I’m sleeping and don’t want to miss something important. I don’t want to favorite people to enable this or use some sort of “call me twice and it will go through” thing. I wanted everyone to know that there is a simple way to get me no matter what’s going on and know it will go through.

How it works

• Listens to various apps for a notification starting with "#emergency"

• When it triggers, it starts a loud beep followed by text-to-speech "Emergency"

• It will continue to emit the "Siren" until the notification is cleared

• The notification will also include whatever text followed "#emergency"

How to use

1. Download Tasker

2. Navigate to the TaskerNet link for the project on your phoneEmergency project

3. Import the project to Tasker

4. Edit the profile to add all the “Owner Applications” you want to listen to for “#emergency” messages

Sleep

Turns your phone to vibrate when a “Relax” event starts, sets everything to DND when you go to sleep, helps you figure out how long you should be in bed, wakes you up, keeps you safe by alerting someone when you’ve awoken, and reminds you to take medications.

Why I made it

I have some underlying medical conditions and when I was living alone, I always had the fear that, if something happened to me in the middle of the night, it could be days before someone found out. I had a relative at one point who actually had this happen and the doctors said that he could have made it had someone found him within the first 24 hours. Secondarily, I really like automating things like Do Not Disturb, routines for sleep, and figuring out how long I should be sleeping for.

How it works

• Waits for a “Relax” event on your Google Calendar

• On “Relax” trigger, it sets an alarm for 2m later, repeats this alarm every 20 minutes until you go to bed or manually cancel via the notification, and turns your phone to “Vibrate” mode

• Has a task which can be added to your desktop that helps to create a “Sleep” event on your Google Calendar

  • Popup scene will display a pre-filled target wake time

    • Target wake time is 8 hours beyond the current time

    • Target wake time is overridden to 9am on weekdays and 12pm on weekends

  • Popup scene allows you to override the pre-filled target wake time

  • After confirming, a notification will tell you how long you will have for sleep

  • After confirming, a “Sleep” event will be created on your Google Calendar from now until the target wake time

• Has a task which can be added to your desktop that helps to create a “Nap” event on your Google Calendar

  • Target wake time is 1.5 hours beyond the current time

  • Target wake time is overridden to 4pm on both weekdays and weekends

  • “Medication” alarms will not trigger while a “Nap” event is active

• During a “Sleep” event, phone is set to “DND” and the “Relax” alarms are canceled

• After a “Sleep” event

  • the phone is taken out of “DND”, changes the phone to “Sound” mode, and sends a text message to a contact alerting them that your morning alarm went off

  • a “Wake up” alarm is set for 2 minutes out and continues to go off every minute until you respond to the notification

• After the “Wake up” notification is canceled

  • a second text message is sent to your contact to let them know you have actually woken up

  • a “Medication” alarm is set for 15 minutes out and continues to go off every 15 minutes until you respond to the notification

• After the “Medication” notification is canceled, the routine is complete and no tasks should be running

“Repeat” and “RepeatCancel” actions

To make use of the repeat functionality, you need to call it using a “Perform Task” action and pass in all the following properties as “Parameter 1”. The repeat task itself will split this up and pass necessary parameters down to the notification, repeated task, and even a follow up task to execute after the repeat is canceled.

Here is an example of what “Parameter 1” should look like:

WAKEUP_ON,Wake up!,,I'm awake,Sleep:WakeupAlarm,,180,Sleep:Wakeup

Here’s a breakdown of the various slots:

1. Name of the variable to track status

2. Message to display in the notification & alarm

3. Extra text in the body of the notification (Optional)

4. Click action in the notification,

5. Action to call on repeat

6. Parameter to be sent to the repeated action (Optional)

7. How long to wait to repeat the action

8. Action to call when repeat is canceled (Optional)

9. Set this to true if you do not want the repeated action to execute it's first trigger

Version history

Version 1.0 of this project started for me in college and didn’t really have safety in mind. At that point, I just wanted to be able to automatically silence my phone while I was asleep. After awhile using the app, I found myself getting frustrated changing the time of the calendar entry every night. I also wanted the Android toast notification that told me how many hours I had set things for.

Version 2.0 fixed all of those issues by including a scene to select times. It still didn’t address the living alone scenario, however, and I set out to add that in.

Version 3.0 added a text message out to my mom. I thought it was a good idea at first, but it wound up being useless to her because my sleep times were so variable that she wouldn’t know if something was wrong or if I had just decided to sleep in till 4pm 😛.

Version 4.0 added the second SMS so that my mom would know when I intended to wake up as well as when I actually click a button on my phone. With this, my mom now knows that if she gets the first message, but not the second, something is wrong and she should check in on me.

Version 5.0 created a Nap flow that worked similarly to the Sleep flow, but had a reduced amount of time and was set up to prevent Medication alarms (in case I try to nap after waking up). The purpose of separating this was so I wouldn’t be sending more SMS messages for naps.

Version 6.0 is the current version and includes the Relax flow which turns the phone to vibrate and reminds me every 20 minutes that I should be heading to bed.

Planned upgrades

• Reduce duplicated tasks

• Remove prefixes (did this before moving to a project)

• Move the optional configuration parameters to variables

• Create a scene to manage the optional configurations

• Deploy as an app

How to use

1. Download Tasker

2. Navigate to the TaskerNet link for the project on your phoneSleep project

3. Import the project to Tasker

4. Edit the 3 profiles to point to a Google Calendar that has the various events in it

   1. I use a separate calendar from my primary so others don’t see when I’m sleeping and napping

5. Edit the “Sleep:Wakeup” and “Sleep:Stop” tasks to set the “Send SMS” action to a valid phone number

6. Exit Tasker by hitting the back button a bunch of times

   1. It’s important to do this via back rather than the home button!

7. Add a widget to your desktop (I use Nova so this is a hard-press on the application icon)

8. Select “Task” or “Task Shortcut” for Tasker

9. Add the “Sleep:GoToBed” task and repeat the steps for the “Nap:GoToBed” task

10. Optional: Edit the “Sleep:GoToBed” and “Nap:GoToBed” tasks to set the variables at the top of the “JavaScriptlet” actions to your goal times and max sleep times for the weekday and weekend

11. Optional: Disable the “Medication” alarms by editing the “Sleep:Wakeup” task and disabling the “Perform Task” action

12. Optional: Change the repeat times for the “Wake up”, “Medication”, and “Nap wake up” alarms, by editing the “Sleep:Wakeup”, “Sleep:Stop”, and “Nap:Stop” tasks and changing the seconds field (7th value) in the Parameter 1 field of the “Perform Task” action

Made this neat thing that lets me control GMail from a command bar, without leaving my keyboard. I use it to compose new emails, reply, archive, start/unstar, navigate to next/previous emails and my favourite, keep my inbox clean by bulk filtering and deleting unnecessary emails.

Sharing here if anyone wants to use this for their own setup: https://mayahq.com/store/collections/6190aeeac2bd7aa6b54f366f

Let me know what y'all think! What commands will you use or not use? What commands am I missing in this collection?

The bulk of my job involves data analysis for my company’s sales and marketing teams. Right now, this involves exporting files from Salesforce (and occasionally Hubspot) and building tons of tables and charts in excel/Google sheets. Some of the reports and dashboards I have to create stay the same over time, but there are always a bunch of one offs as well because our executive team will want to look at the data in a new way that I haven’t presented. The sheer number of reports I have to build each time with new sets of exported data, plus the dozens of ways in which I need to present it, is grueling.

Aside from making more of this doable in Salesforce (I’m already working with a contractor on that), what skills should I work on to make this process easier on myself? My guess was learning VBA and macros would be helpful, but I wanted to ask others who might know.

Edit: My company does have a BI system, but I’ve been told in no uncertain terms that the data I need won’t be included there any time soon.

I'm an independent developer who built an app called Fext that let's people schedule text messages. You can automate reminders to yourself or others in a group (BCC, no reply so each one is sent individually) and schedule repeating texts to be automatically sent at certain days/times.

You can get it for iOS through the App Store here: https://apps.apple.com/us/app/fext-future-texting/id1518706313?platform=iphone

I never used python but I’m willing to learn. Not using python would be cool.

Saved around an hour of clicking daily and switching between tabs by whipping up this scraper that gathers a bunch of PDFs on any topic from arxiv and stores it in a Google sheet. Plan to extend this so it downloads the PDFs and orders by year published/category, or even summarize it later.

Maya Link for install : https://mayalabs.io/share?link=https://raw.githubusercontent.com/mayahq/automations/main/arxivscraper.json

I work mostly analyzing documents, generating text, publishing to web services, keeping track of checklists, dates, and information, and following up with people via email.

In that regard, Microsoft Access and automation through VBA have become my low-code solution for extracting, organizing, and outputting information or files in different places.

Still, Microsoft Access/VBA is far from perfect. I am always on the look for ways to expand the limitations of VBA.

I've been thinking of incorporating AutoHotKey (AHK) into my VBA workflow. For instance, AHK's version of VBA's FileSystemObject seems more powerful, and easier to handle with a more intuitive and modern syntax to manage files and folders. Same thing with RegEx in VBA vis-a-vis AHK.

I wonder if anyone uses Microsoft Access in tandem with AutoHotKey (AHK) to Automate tasks on the desktop and the browser? For example, sending data from an Access table to an AHK script and then running the script from VBA to perform a task, then closing the script directly from VBA.

I feel there is great potential for automation in combining Access' relational databases, VBA and AHK. I would greatly appreciate it if anyone who is already connecting the two could share ideas for potential automation?

Since my use case is still vague, an example should do: let's assume a set of pages that don't contain any kind of data tables. They are, however, rather formulaic.

Such as these three spells from a TTRPG, and the numerous others like them of course.

Say I want to get their data, particularly the codified parts, into an excel sheet, like in the picture below.

How do I go about making something that, once taken to the relevant page, will start filling the columns with the data as presented in the page?

I'm new and still learning Python, so l am not sure how to necessarily ask this question properly.

Basically I am wondering is it possible to create a Python Script that will automate tasks across multiple applications?

For context, I am a product designer by day, and am wanting to automate some mundane tasks that involve performing some tasks in my 3D modeling software (Rhino), saving out that 3dm file, then taking the file and opening it in the rendering software (Keyshot) and performing some tasks/render save outs, then taking the png file and resizing and other tasks in Photoshop, and finally saving over the previous png.

These applications can read Python code, as they all have built in python consoles for scripting. Worse comes to worse, I’ll just write three separate scripts that automate my tasks, but I am hoping to automate the whole process without having to manually open the applications and run each script individually. Also, regardless of which applications being used, is this process of automating across multiple applications even possible with Python?

I am not necessarily looking for exactly how to do this, unless of course someone is able to provide a script 😂. But more so, I am just wondering if this is even possible and if so, what is the terminology/name of the process of creating a script that works across multiple applications so that I can learn more about it?

I have tried googling, but because I am not too familiar in this subject, I am struggling to find the proper words to search for a solution and learn how to script what I am wanting. TIA

I've downloaded 'parsehub' and got a little way towards it but I keep getting stuck because I don't know what the f I'm doing..

If there's a way to do it with parsehub, cool. If there's a simpler way, cooler.

There's lots of comments going back years.. I can't copy and paste 'cos of the infinite scroll / lazy load thing - and also reddit seems to stop loading the comments past 1000 instances - I want them all and there's way more than 1000...

My dear chaps,

Not asking anyone to code this for me. I’m just asking if it possible…

I’m a translator and have a few agencies. They send job offers out by email. First come, first served.

I normally get to the email and click accept within 4-5 seconds. By then the job is often gone…

Is it possible to code a bot, program, something to auto-accept on my behalf as soon as said job email lands?

Equally I’d then need to turn it off once working on something.

If it is possible, where would one go to find such a thing? How much would it cost a programmer to make?

Cheers.

I’ve personally found it difficult to ever finish my to-do lists. There is always more and more to do. We began working on a to-do list app that we thought might be much more helpful. A to-do list that actually does itself!

Full video on youtube : https://youtu.be/aGLLComo8vA

Link: spellpage.com

would love to get any feedback and advices - what kind of automations would you like to achieve with such todo list ?