Online merchants who sell goods and services and use PayPal for payment processing can benefit from this blog. The blog describes steps to automatically download daily transactions and money transfer from PayPal into Google Sheets. This automation can help save time and reduce back office cost. Linking PayPal with Google Sheets is easy. Follow the […]
Recent Posts
Spending Sheet
HuG February 1, 2020 No Comments Cloud, Google Sheets
Looking for a new and existing way to track your personal finance or petty cash? How about speaking naturally? If opening spreadsheet and scrolling up and down bores you; and you still want to track how money goes in and out your wallet then try this google sheet add-on google sheet add-on. This google sheet […]
Prep notes – AWS Certified Associate Architect
HuG December 28, 2019 No Comments AWS, Cloud aws associate architect, aws certification, aws exam, aws notes
Preparing and successfully passing AWS CAA exam is an exciting journey. Congrats on making the decision to undertake this journey. Here are some prep notes on AWS services that can augment your exam preparation. For me, they came in handy during the final days before the exam. This blog can serve as a good starting […]
Google Sheet – Get Day from Date
HuG November 13, 2019 No Comments API, Cloud, Google Sheets
How to get day of the week in Google Sheet At times we want to show day of the week along with the date on the google sheet. The day gives us a fair idea of what to expect when planning an event like birthday party or a conference. Attendance at parties and conferences can […]
How to Load csv into AWS dynamoDB
HuG February 27, 2019 No Comments AWS, Cloud aws-s3-lambda, dynamoDB
This blog describe one of the many ways to load a csv data file into AWS dynamodb database. This option described here leverages lambda service. AWS lambda is server-less; so no need to setup and configure a server. Further, AWS Lambda gives flexibility to pick language of choice. This blog show a lambda function in […]
Gmail – API : 3 parts
HuG January 19, 2019 No Comments API, Cloud, Gmail gmail-api
Google provided suite of API for its services. Gmail API can be used in a number of ways to manage and review messages in inbox.
AWS – Start EC2 using Lambda and cron
HuG January 15, 2019 No Comments AWS, Cloud aws-ec2-lamdba
Python code to get instance-id of EC2 instances using tag. After obtaining the instance-id use it to automatically launch the instance to perform tasks