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 […]
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 […]
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 […]
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 […]
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 […]
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.
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