Date and time​

• Find the next Sunday date.
• Download emails received today with the date format "dd/mm/yyyy".
• Convert from format "MM/dd/yyyy hh : mm : ss" to format "yyyy-MM-dd hh : mm : ss".
• Put a one second delay.

Text and number​

• Get last 4 digits.
• Get filename from full path.
• Verify if the result is a palindrome.
• Return the first palindrome number greater than 152.

Data operations​

• Fix the expression by declaring and initializing the variable before calling the first method on it.
• Store the list of strings inside an array.

Files operations​

• Get all .pdf files from the folder.

Excel operations​

• Read ranges B3 to B9 from the Excel sheet.

Storage services​

• When a new PDF is created in OneDrive, split its pages into separate files.
• Combine all PDF files in a OneDrive folder into a single PDF file and upload the merged file to a specified folder.
• Every Saturday, connect to our OneDrive and backup to AWS cloud storage all the new files added in the 'Projects' folder during the week.
• Upload signed Documents from DocuSign to Dropbox.

Communication services​

• Send the recording on Slack once recording is ready on Zoom.
• Send an SMS message via Twilio when a high-priority incident is created in ServiceNow.

Microsoft 365​

• When a new row is added to the vendors table notify the team over Slack and confirm via Microsoft Outlook.
• Add a new line to an Excel Spreadsheet for every unread email in an Microsoft Outlook folder, then mark the email as read.
• Create a flow that reads through the emails in a particular folder using Microsoft 365. Then Download the attachments, only consider those that are PDF. Then read the text from the PDF.
• Extract data from a new invoice file in once drive and store in Excel.
• Notify me on Teams when a critical bug is created in Jira.
• I need to extract the latest Bitcoin data from Yahoo Finance and write it to an Excel.

Google Workspace​

• Extract data from a new invoice file in Google Drive and store it in Google Sheets.
• Download new Zoom Recordings as video files and upload them to Google Drive.
• Trigger an automation from Gmail and store the attachment in the Google Drive.
• Create a new entry in Google Sheets for a new customer support ticket from Zendesk.
• Extract the latest 100 emails from Gmail from the current month and create a Google Sheets Report with the sender and subject.
• For new invoices received to Gmail create an expense report using Expensify.
• Summarize new Gmail email using OpenAI and share the summary via Slack.

Salesforce​

• For a new Salesforce lead, generate a personalized email using OpenAI and send the email via Outlook.
• When a Salesforce opportunity is won, post a kudos message to Slack.
• Send me a message to Teams when a new lead is created in Salesforce.
• Whenever a lead's status changes in Salesforce, send a notification on Slack to the sales team with the lead's details.

OpenAI​

• Scrape product, price and rating from provided URL, send the result to OpenAI to find the best option considering rating and price.