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