Power Tools: ExtractText("Hello World", "Hello") - Extracts the word "Hello" from the text "Hello World."
Remove Duplicates: RemoveDuplicates(A2:A10) - Removes duplicate values from cells A2 to A10.
Supermetrics: SupermetricsQuery("SELECT * LIMIT 10") - Fetches the first 10 rows of data using a Supermetrics query.
Search Analytics: SearchAnalyticsQuery("query" ; "web" ; "date") - Retrieves search analytics data based on the specified query, device, and date range.
Doc Variables: DocVar("variable_name") - Inserts the value of the specified document variable into the cell.
SmartSheet: SmartSheetCells("sheet_id", "column_id", "row_id") - Fetches cell values from SmartSheet based on the provided IDs.
Mapping Sheets: GetLocation("New York") - Retrieves the latitude and longitude of the specified location.
Cryptosheets: GetCryptocurrency("BTC") - Fetches the current price of Bitcoin in USD.
Yet Another Mail Merge: YAMM_CountSentEmails() - Counts the number of sent emails using Yet Another Mail Merge.
Blockspring: BLOCKSPRING.FUNCTION_NAME() - Accesses various data and service-related functions provided by Blockspring.
ImportJSON: ImportJSON("URL") - Imports JSON data from the specified URL into Google Sheets.
Form Publisher: FormPublisherSendEmails("template_id", "recipient_email") - Sends personalized emails based on a template to specified recipients.
QR Code Generator: QRCode("Text to encode") - Generates a QR code for the given text.
EASYCASE: UpperCase("hello") - Converts the text "hello" to uppercase ("HELLO").
AdStage: AdStageMetrics("account_id", "metric", "start_date", "end_date") - Retrieves advertising metrics for the specified account, metric, and date range.
TranslateMySheet: Translate("Hello", "en", "fr") - Translates "Hello" from English to French.
AutoCrat: AutoCratMerge("template_id") - Merges data into the specified template using AutoCrat.
Trello: TrelloCard("card_id") - Retrieves details of the Trello card with the given ID.
YouTube Analytics: YouTubeAnalytics("channel_id", "start_date", "end_date") - Fetches YouTube channel analytics for the specified date range.
CSV Importer: CSVImport("URL") - Imports data from a CSV file hosted on the specified URL.
Split Names: SplitNames("John Doe") - Splits "John Doe" into two separate cells with first and last names.
Timer for Trello: TimerStart("card_id") - Starts a timer for the specified Trello card.
Twitter Archiver: TwitterArchiverSearch("query", "since_date", "until_date") - Archives tweets matching the query and date range.
ChartExpo: ChartExpoCreate("chart_type", "data_range", "options") - Creates a chart based on the specified data and options.
Email Spreadsheets: EmailSpreadsheet("recipient_email") - Sends the entire spreadsheet as an attachment to the recipient's email.
Charts: ChartMogul("metric", "start_date", "end_date") - Fetches subscription metrics from ChartMogul for the specified date range.
Countdown: Countdown("2023/12/31") - Calculates the days remaining until December 31, 2023.
FormRanger: FormRangerSetChoices("form_id", "sheet_name", "range") - Sets the choices in a Google Form based on the specified range in the spreadsheet.
HiMama: HiMamaFetchChildren("center_id") - Retrieves a list of children associated with the specified childcare center ID from HiMama.
Mergo: MergoPDFs("pdf_1", "pdf_2") - Merges the two specified PDF files into a single PDF.
OpenSolver: OpenSolverSolve() - Solves optimization problems using OpenSolver.
PDF Mergy: PDFMergyMerge("pdf_1", "pdf_2") - Merges the two specified PDF files into a single PDF.
Quick Maps: QuickMaps("location") - Generates a map with a pin at the specified location.
Ribbon: RibbonOpenSidebar("sidebar_title") - Opens the specified sidebar in Ribbon.
SheetGo: SheetGoCopy("source_spreadsheet_id", "destination_spreadsheet_id") - Copies data from the source to the destination spreadsheet.
Tiller Money: TillerGetTransactions("account_id", "start_date", "end_date") - Retrieves bank transactions for the specified account and date range.
Form Recognizer: FormRecognizerAnalyze("image_url") - Extracts information from the specified image using Form Recognizer.
Analytics Canvas: AnalyticsCanvas("query", "property_id", "view_id") - Fetches Google Analytics data using Analytics Canvas.
Data Everywhere: DataEverywherePull("source_spreadsheet_id", "source_range", "destination_range") - Pulls data from another spreadsheet using Data Everywhere.
EasyQA: EasyQAGetResults("project_id", "test_run_id") - Retrieves test results from EasyQA for the specified project and test run.
OneSignal: OneSignalSendNotification("app_id", "message") - Sends a push notification to the specified app ID using OneSignal.
ScriptEditor: ScriptEditorRunFunction("function_name") - Executes a specific function within the Google Apps Script editor.
Sheets Macros: SheetsMacrosRun("macro_name") - Runs a specific macro within Google Sheets Macros.
Translation Services: TranslationServicesTranslate("text", "source_language", "target_language") - Translates the specified text between languages using Translation Services.
Twitter Curator: TwitterCuratorSearch("query", "since_date", "until_date") - Fetches tweets matching the query and date range using Twitter Curator.
Document Studio: DocumentStudioGenerate("template_id", "folder_id", "document_name") - Generates a new document from the specified template using Document Studio.
Easy Projects: EasyProjects("task_id", "status", "start_date", "end_date") - Retrieves task details from Easy Projects based on the specified parameters.
TractionGuest: TractionGuestGuests("location_id", "start_date", "end_date") - Retrieves a list of guests for the specified location and date range using TractionGuest.
UPilot: UPilotLeads("start_date", "end_date") - Fetches leads from UPilot for the specified date range.
User Defined Functions: UserDefinedFunction("parameter_1", "parameter_2") - Implements custom functions using User Defined Functions.
Comments
Post a Comment