A repository for my google scripts (GS).

Scripts:

• SQLQueryToGoogleSpreadSheet - Take a query and bring data to Google Spreadsheet.
• fromGooglePlacesToSheet - Take a set of specific places in a sheet with a link to the street view from it.
• getMailToSpreadsheet - Take a email thread by a search criteria to a Google Spreadsheet.
• introToGoogleAppsScript - Examples for explain variable, if condition, loop and API use for my informatic classes (in Portuguese).
• createKeyFromEmail - Create a sequence os random numbers with the user in the email.
• unixTimestampToDate - Transform unix timestamp to Date for example usage:spreadsheets.
• formToPdf - Take every response in a form and tranform in a Google Document and also a PDF, after send an email with the two links for the files.
• bitcoin_value_and_compare_currencies - The script used to analyse Crypto currencies and you can find here.
• getCryptoInDollar - Function used to convert from crypto currency for US Dollars.
• importJurusDataToSpreadsheet - Create a menu item to import data from Jurus.
• google-sheets-functions-to-trello-api - A set of functions to use Trello's API.
• sendEmailViaSendGrid - A function to send email via SendGrid's API.
• google-sheets-functions-to-zoom-api - A set of functions to use Zoom's API.
• uploadZoomRecordingsToDrive - Get Meeting records, upload to Google Drive and delete files from Zoom account.
• fufilColumn - Fulfil columns with trigger
• translateEN2PT - Translate one column frm Google Sheets to another column
• queryAPITextRazor - send data to TextRazor API to NLP.
• generateJSON - generate a JSON with 3 levels
• findRow - find a row and return a value in the row
• random1_1 - randomize 1-1 for squads
• buildSankeyGraph3Levels - build a three level sankey graph
• splitCellToRows - take a column and with a delimiter create new rows
• callZapierWebhook - call a webhook from Zapier to process a batch
• extractSpeechFromPdf - get speech from a pdf file