0CodeKit and Google Sheets Integration
Demonstration of how apps are integrated in WEXTL workflow builder[4]
Connect 0CodeKit and Google Sheets to automate developer tools workflows. Trigger events from one app, run actions in the other and use AI to make smart decisions. Integrate apps in 3 simple steps - no code required.
- 3-day trial
- Cancel anytime
- Up to 10 minutes quick set up
- GDPR
- Data Encryption
- 2FA
- Local Data Region
Learn about 0CodeKit and Google Sheets
Detailed info you need to know about 0CodeKit and Google Sheets integrations in WEXTL. Explore which modules apps support and how you connect them.
0CodeKit

PDF, image, AI, data validation and conversion tools for automations.[5]
Google Sheets

Read, write, append, and batch-update spreadsheet data in Google Sheets with dynamic sheet pickers.[6]
How to connect 0CodeKit to Google Sheets
Set up your 0CodeKit and Google Sheets integration in 3 simple steps[2]. No coding required. Up to 10 minutes setup.
STEP 1
Connect 0CodeKit and Google Sheets
Save credentials in WEXTL once. We store them encrypted and reuse the authorization across every workflow[3]. No coding or API skills required.
STEP 2
Build a workflow
Paste selected 0CodeKit and Google Sheets nodes onto the canvas[4], or describe what you want and WEXTL wires the flow together with AI Builder.
STEP 3
Map your data
Choose which fields need to sync between 0CodeKit and Google Sheets. Use filters or a JS custom code step in between. Everything is on the canvas.
How does the integration between 0CodeKit and Google Sheets work in WEXTL?
WEXTL exposes actions and triggers for 0CodeKit and Google Sheets that help you connect apps and automate repetitive tasks[1]. A trigger is an event that happens, and an action is a step that performs when the event has occurred.
Google Sheets triggers0CodeKit actions
Google Sheets modules
- Append a Row Adds one row to the end of a sheet and fills each column header with its value. Use Value Input Option to treat input as RAW or as USER_ENTERED.
- Append Multiple Rows Writes many rows below the data of a sheet in one request. Use Rows to list them, and Insert Data Option to overwrite existing cells or insert new rows.
- Append Values Places values below the existing data of a range, located by Spreadsheet ID, Sheet Name and Range or by Select From Drive. Turn on Include Values In Response to return the written cells.
- Batch Clear Values Clears the values of several A1 ranges in one request. Returns Spreadsheet ID and Cleared Ranges. Clear Values handles a single range.
- Batch Clear Values by Data Filter Clears the values of all ranges that match your Data Filters. The result lists the Spreadsheet ID and Cleared Ranges.
- Batch Get Values Reads several ranges in one call and returns them as Value Ranges. Use Value Render Option for formulas or computed values and Date Time Render Option for serial numbers or formatted dates.
- Batch Get Values by Data Filter Reads all ranges matched by your Data Filters, with no fixed A1 addresses. Returns each matched range as Value Ranges. Use Major Dimension for rows or columns.
- Batch Update Spreadsheet Applies a list of Requests to a spreadsheet, such as addSheet, merge cells or repeatCell formatting. Returns the Replies. Turn on Include Spreadsheet In Response to get the updated file.
- Batch Update Values Writes several ranges in one request from Data. Use Value Input Option to set how values are parsed. Returns totals for updated rows, columns, cells and sheets, plus per-range Responses.
- Batch Update Values by Data Filter Writes your Data into the ranges that Data Filters match instead of fixed cell addresses. The result gives updated cell totals and per-range Responses.
- Clear Values Clears the values of one range and keeps its formatting. Returns the Cleared Range. Batch Clear Values handles several ranges.
- Copy a Sheet to Another Spreadsheet Copies a sheet tab into a Destination Spreadsheet. Returns the Sheet ID, Title and Index of the copy.
- Create a Spreadsheet Creates a spreadsheet with a Title, plus optional Locale, Time Zone, Auto Recalc and starting Sheets. Returns the Spreadsheet URL and ID.
- Get a Developer Metadata Entry Reads one developer metadata entry of a spreadsheet by its Metadata ID. Returns the Metadata Key, Metadata Value, Visibility and Location.
- Get a Spreadsheet Returns the properties of a spreadsheet and its list of sheets. Trim the output with Ranges and Fields. Set Include Grid Data to add cell contents.
- Get a Spreadsheet by Data Filter Returns a spreadsheet with grid data limited to what your Data Filters select. Set Include Grid Data to add the matching cells.
- Get Values Reads the cells of one range. Returns the Range, its Major Dimension and a Values array. Set Value Render Option for formatted, unformatted or formula output.
- Make an API Call Calls the Google Sheets REST API directly with a free-form request under your saved credential.
- Search Developer Metadata Finds developer metadata entries that match your Data Filters and returns them as Matched Developer Metadata.
- Update Values Overwrites one range with Values. Set Value Input Option to read input as RAW or USER_ENTERED. Returns the Updated Range and counts of updated rows, columns and cells.
- Watch New Rows Checks a sheet on your schedule and starts the workflow once for every row added since the last check. Each row brings its Row Number, the sheet name and its cell Values.
0CodeKit modules
- Add a Text Watermark to a PDF Writes Text across the pages of a PDF. Control its look with Font, Size, Color and Opacity, and tile it with Repeat and Spacing.
- Add an Image Watermark to a PDF Stamps an image over the pages of a PDF, either once or tiled with Repeat. Place it with Anchor, X and Y, size it with Width and Height, and set Opacity and Rotate.
- Add PDF Pages Inserts blank pages into a PDF. Use Pages to list the positions after which they go, and Width and Height to size them.
- Blur an Image Blurs an image by the Sigma strength and returns the URL of the blurred copy.
- Build a UTM Link Appends campaign tracking parameters from UTM to a URL and returns the finished link.
- Calculate BMI Works out the body mass index from Weight in kilograms and Height in centimeters. It also reports the BMI Classification, Kcal and Nutrients.
- Calculate Distance Measures the route between a Start Point and an End Point for a travel Mode, returning the Distance In KM and Duration.
- Check a Content Policy Screens a Prompt against content policy and reports whether it is Safe.
- Check a Freemail Address Tells whether an Email belongs to a free mailbox provider, and names the Provider.
- Check a Rate Limit Acts as a traffic light under a Name. It lets a request through only after the Interval since the last allowed one and reports Ok.
- Check a Weekend Checks whether a Date falls on a Saturday or Sunday, with Is Weekend and the Week Day. Use Time Zone for local dates.
- Compare Strings Scores how alike two texts are, returning a Similarity and a Distance. Use Algorithm to choose the similarity method.
- Compress a PDF Shrinks the file size of a PDF and gives you a link to the smaller version under File Name.
- Concatenate Audio Files Joins several Audio files into one in the chosen Format, with Silence added in between if wanted.
- Convert a Country Name and ISO Code Looks up the Nation name for an ISO code, or the ISO code for a Nation, in a single call.
- Convert a Currency Changes an Amount from a Source Currency to a Target Currency and returns the Converted Amount.
- Convert a DOCX to a PDF Converts a Word document into a PDF with 0CodeKit and returns its URL.
- Convert a Markdown to a PDF Renders a Markdown String as a PDF, styled with Css.
- Convert a PDF to an Image Renders the pages of a PDF as images and returns the Result.
- Convert a PDF to Base64 Encodes a PDF as text and returns the PDF Base64 with its File Name.
- Convert a Time Zone Moves an Input Time from the Input Time Zone to the Destination Time Zone. Use Format Pattern to shape the output.
- Convert an Image Changes an image to the Output Format you want. Turn on With Meta Data to keep its metadata.
- Convert an IP to a Location Looks up an IP address and returns its Country, Region Name, City and Zip.
- Convert an Outlook Message to JSON Reads an Outlook MSG file and returns its content as a Result in JSON.
- Convert CSV to an Array Parses CSV text split on the Delimiter into an Array of rows. Turn on Omit First Row to skip the header.
- Convert CSV to JSON Parses CSV text and gives one object per row. Use Noheader, Trim and Ignore Empty to adjust how rows are read, and Delimiter to split the columns.
- Convert HTML to a PDF Prints HTML, or a web page found at a URL, into a PDF. Use File Name to label the file.
- Convert HTML to an Image Renders HTML, or the web page at a URL, into an image. Options adjust the rendering.
- Count PDF Pages Counts how many pages a PDF holds and returns the Page Count, from a File URL or File Content (Base64).
- Create a Global Variable Saves a Variable Value under a Variable Name in 0CodeKit storage. A name is generated when none is set.
- Create a JSON Bin Stores a JSON document in a new bin and returns the Bin ID.
- Create a Scheduler Task Schedules a webhook call that carries Data. Use Interval Type to run it once, on a Cron Expression or Every so often, until the End Date.
- Create a Shortened URL Makes a short link for a Destination. Use Custom to choose the short identifier.
- Create an Empty PDF Builds a blank PDF with a number of Pages at the chosen Width and Height.
- Crop an Image Trims an image down to the area defined by Left, Top, Width and Height.
- Cut Out an Image Background Removes the background of an image with AI and gives you the URL of the cut-out file.
- Decode a Barcode Reads a barcode from an image and returns the Code it holds. Use Barcode to tell the reader which format to expect.
- Decode a JWT Opens a Token and returns its Result. Turn on Verify, with a Secret, to check the signature.
- Decode a QR Code Reads a QR code from an image and returns its Data.
- Decrypt a PDF Unlocks a protected PDF with its Password and gives you the URL of the open copy.
- Decrypt Text Turns a Ciphertext back into readable text using the Crypto Type and Secret Key.
- Deduplicate a List Removes repeated entries from a List and returns what is left.
- Delete a Global Variable Removes a global variable from 0CodeKit storage.
- Delete a JSON Bin Deletes a stored JSON bin in 0CodeKit.
- Delete a Permanent File Deletes a file from permanent storage in 0CodeKit.
- Delete a Scheduler Task Removes a scheduled task from 0CodeKit.
- Delete a Shortened URL Removes a short link from your 0CodeKit account.
- Detect a Brand Spots logos in the image at an Image URL and lists the Brands it recognizes.
- Detect a Color Analyses an image from its Image URL and reports its Dominant Colors, Accent Color and whether it Is Bw Img.
- Detect a Face Counts the faces in the image at an Image URL, with the Total Faces and their Faces Position.
Explore alternative integrations
There are other apps[9] supported by WEXTL that can be paired with 0CodeKit and Google Sheets integrations. Pick any from the list below if the current combination isn't the one you need.
Frequently asked questions
Common questions about connecting 0CodeKit and Google Sheets.
References
List of sources used to gather information about the 0CodeKit and Google Sheets integration.
- 0CodeKit and Google Sheets integration source code, module specs and credentials implementation.
- Our 0CodeKit and Google Sheets integration documentation, structured input and output parameters, scopes, and authentication methods.
- Official vendor API documentation for 0CodeKit and Google Sheets, used to verify field meanings, authentication flows, and anything our own specs don't fully capture.
- WEXTL® visual workflow builder, anonymized data from our technical support team.
- 0CodeKit integration information
- Google Sheets integration information
- WEXTL® Scheduling
- WEXTL® Pricing and Trial
- WEXTL® Apps Library
How we write our apps documentation
Explore how WEXTL® crafted 0CodeKit and Google Sheets integration page documentation. Used sources, the role of AI, and how the team validates the result.