- Create a bot using @BotFather, get it's token
- Start conversation with bot
- Run following curl command
curl https://api.telegram.org/bot/getUpdates | grep -Po '"from":{"id":.+?,'
curl https://api.telegram.org/bot/getUpdates | grep -Po '"from":{"id":.+?,'
function downloadUnreadEmails() { | |
var sheet = SpreadsheetApp.create('Unread Emails'); | |
sheet.appendRow(['Sender', 'Subject']); | |
var threads = GmailApp.search('is:unread'); | |
for (var i = 0; i < threads.length; i++) { | |
var messages = threads[i].getMessages(); | |
for (var j = 0; j < messages.length; j++) { |
function deleteEmails() { | |
var sheet = SpreadsheetApp.openById('SHEET ID').getSheetByName('Sheet1'); | |
var data = sheet.getDataRange().getValues(); | |
for (var i = 1; i < data.length; i++) { | |
var sender = data[i][0]; | |
var subject = data[i][1]; | |
var threads = GmailApp.search('is:read from:' + sender + ' subject:' + subject); | |
Logger.log('Deleted' + i + ' emails') |