RPA with help of Open AI ChatGPT

Amit Shukla
3 min readApr 20, 2023

--

In this series, we will write snippets of Python code used in Automation tasks and later, will put it all altogether to deliver an RPA project.

I am Amit Shukla, and I have been working on automating RPA tasks for over a decade now. Since the recent launch of ChatGPT, I am exploring ways to use its coding skills to automate small daily routines.

In this RPA series, we will use ChatGPT’s code writing skills to build a trading bot from scratch. I do not view ChatGPT as a threat to my job, at least not yet. Instead, I believe it can assist me in writing smarter solutions to solve more significant problems.

This tutorial series does not focus on using ChatGPT for everything, nor does it address the pros and cons of AI writing codes. Instead, we concentrate on RPA tasks and utilize ChatGPT’s help where appropriate.

The notebooks included in this repository are beginner-friendly code snippets for automating small tasks and every line of source code is included here in this GitHub repository.

working with os and files

Splitting big file and combining it back

Splitting CSV file by rows and combining it back

File Encrypt and Decrypt

Data Masking and Unmasking

Search and replace over a large number of text files

Rename and rearrange files using os and shutil module

web scrapping

Screenshot of a web page

Read text from Images

Scrape text from web page

Scrape emails, phone number, URL from given text

Download a file from a URL

Download all files from a web page

Scrape and download CSV PDF image files from web page

Keep moving mouse to avoid os sleep mode

Boost Your YouTube Views Legitimately

miscellaneous

Generate and Read QR Code

Generate Image Watermark

Tic Tac Toe

Mass calculation

Basic Scientific calculator

Count down timer

Timer

World clock

Alarm clock

Boxing match timer for 10 rounds 3 mins each with 2 min break

Jump rope counter

EMOM Timer

TABADA Timer

Reading a cookie file

Create fake test data using ChatGPT

conversions

Convert Images to PDF

Convert PDF to CSV

Convert CSV to DSV

Convert Text to CSV

Convert Images to Text

Compress and Decompress CSV file

Compress and Decompress Image file

Compress and Decompress Audio file

Compress and Decompress Video file

CRON jobs

Creating a CRON job in Linux

Creating a CRON job in windows

Watching file drop to trigger script

Memory use on windows MAC OS or Linux

In this series, we wrote snippets of Python code used in Automation tasks and later, will put it all altogether to deliver an RPA project.

Here is a list of RPA projects (currently WIP) and will be published as blogs.

  • Python — Introductions to Polars DataFrame
  • Monitoring live web content
  • WIP — RPA to build Open Reconciliation system
  • WIP — RPA to build a Trading BOT
  • WIP — RPA to build Auto Replenishment Inventory Order system
  • WIP — Document scanner — Match Exception Digital Invoice generator
  • WIP — Python network scanner
  • WIP — Stock prices Exploratory data analysis
  • WIP — Python Time Series Forecasting

please follow me at Medium, GitHub, Twitter and subscribe to my YT Channel for more updates.

--

--

Amit Shukla
Amit Shukla

Written by Amit Shukla

Build and Share Quality code for Desktop and Mobile App Software development using Web, AI, Machine Learning, Deep Learning algorithms. Learn, Share & Grow.

Responses (1)