Connect JSON and Google Sheets integrations
Connect JSON and Google Sheets with any of your favorite apps in just a few clicks. Design, build, and automate anything for your work by integrating apps like JSON and Google Sheets to create visual automated workflows. Choose from thousands of ready-made apps or use our no-code toolkit to connect to apps not yet in our library.
Creates a new conditional format rule at the given index. All subsequent rules' indexes are incremented.
Appends a new row to the bottom of the table.
Adds a new sheet.
Appends multiple rows to the bottom of the table.
Updates multiple rows.
Clears a specific cell.
Clears values from a specific row.
Clears a specified range of values from a spreadsheet.
Copies a sheet to another spreadsheet.
Creates a new spreadsheet.
Creates a new spreadsheet from a template sheet.
Deletes a conditional format rule at the given index. All subsequent rules' indexes are decremented.
Deletes a specific row.
Deletes a specific sheet.
Gets a specific cell.
Performs an arbitrary authorized API call.
Returns processed data as a result of the MAKE_FUNCTION or INTEGROMAT function. Sheets Add-On required.
Renames a specific sheet.
Updates a specific cell.
Updates a row.
Returns a sheet’s content defined by range values.
Gets a list of all sheets in a spreadsheet.
Returns results matching the given criteria.
Returns results matching the given criteria. This module doesn't return a row number.
Trusted by thousands of fast-scaling organizations around the globe
Automate your work. Build something new.
Just drag and drop apps to automate existing workflows or build new complex processes. Solve problems across all areas and teams.
Build your JSON and Google Sheets integrations.
Create custom JSON and Google Sheets workflows by choosing triggers, actions, and searches. A trigger is an event that launches the workflow, an action is the event.
Creates a new conditional format rule at the given index. All subsequent rules' indexes are incremented.
Appends a new row to the bottom of the table.
Adds a new sheet.
Appends multiple rows to the bottom of the table.
Updates multiple rows.
Clears a specified range of values from a spreadsheet.
Clears a specific cell.
Clears values from a specific row.
Connect any app with JSON and Google Sheets
Popular JSON and Google Sheets workflows.
Looking to get more out of JSON and Google Sheets? With Make you can visually integrate JSON and Google Sheets into any workflow to save time and resources — no coding required. Try any of these templates in just a few clicks.
[AI Tools 101] AI web scraping with Google Sheets
In this [AI Tools 101](https://www.youtube.com/watch?v=DCz7HCx6HnI&list=PLrED3I754LhmTtlldfGklaEMh-ZaCa3EK&index=9&ab_channel=Make) course template, learn how to scrape web content efficiently using AI and Google Sheets. Extract, structure, and save data seamlessly for enhanced information management and analysis.
TRY IT ->Parse JSON data from a webhook and add it to Google Sheets
Automatically parse JSON data from incoming webhooks and add it to Google Sheets. Streamline data management by integrating Custom WebHook, Parse JSON, and Google Sheets.
TRY IT ->Conduct SWOT analysis on competitors with ChatGPT and store results on a Google Sheet - Quick version
Add competitor websites to a Google Sheet and rapidly perform competitor SWOT analysis using ChatGPT and instantly save insightful data on the same sheet for easy access and improved decision-making. Your sheet must have the following columns: A - Company website B - Strengths C - Weaknesses D - Opportunities E - Threats
TRY IT ->Enrich company data with ChatGPT and Google Sheets
Automatically enrich your company data using the power of ChatGPT integrated with Google Sheets. This template ensures quick access to comprehensive business insights, enhancing decision-making and streamlining your data management processes.
TRY IT ->[AI Tools 101] AI enrichment with OpenAI and Google Sheets
Learn how to enrich your data in Google Sheets using OpenAI's GPT models. This template is part of the [AI Tools 101 YouTube course series](https://www.youtube.com/watch?v=zt0e0Rh7YK4&list=PLrED3I754LhmTtlldfGklaEMh-ZaCa3EK&index=5&ab_channel=Make), offering a step-by-step guide to enhance your datasets with AI-powered insights. Watch the video and follow along to effortlessly extract and update detailed information in your Google Sheets.
TRY IT ->Assess Mailchimp campaign reports with OpenAI and store the results on a Google Sheet
Analyze your Mailchimp campaign performance using OpenAI, and effortlessly save crucial insights on Google Sheets with accompanying improvement suggestions.
TRY IT ->Add Phantombuster phantom results to Google Sheets
Use this template to automatically import Phantombuster phantom results to Google Sheets. Please note that the Phantombuster 'Watch an Output' module returns only 1 (the most recent) phantom output so schedule it in accordance with your Phantombuster scheduling. You can change the scheduling settings by clicking on the clock on the first module.
TRY IT ->Create a new document in AX Semantics from new rows in a Google Sheets spreadsheet.
This template regularly checks for new rows in a Google Sheets spreadsheet and uses the retrieved information to create a new documents in AX Semantics. The template expects that your spreadsheet and JSON structure have 3 columns. You will be able to change the scenario after you up the template in case your spreadsheet has more columns. The template is scheduled to run every 15 minutes. You can change the schedule after you set up the template by clicking on the clock icon on the first module.
TRY IT ->Iterate over a ParseHub dataset and save the result in Google Sheets
This scenario helps you iterate over a ParseHub dataset. At specific intervals, Make will automatically extract and convert the latest data to a JSON file. Then, we use an iterator to parse the data line by line and the result is saved in Google Sheets. This template follows the starting tutorial from ParseHub and will output this [example Spreadsheet](https://docs.google.com/spreadsheets/d/17cC29njZVkFyDVW-tByctlPMpjMVPo3tnxf9tTScYdc/edit?usp=sharing).
TRY IT ->
FAQ
How it works
Traditional no-code iPaaS platforms are linear and non-intuitive. Make allows you to visually create, build, and automate without limits.
Trusted by 500,000+ Makers
"Make really helped us to scale our operations, take the friction out of our processes, reduce costs, and relieved our support team. It is difficult to not become a fan."
"Make drives unprecedented efficiency within our business in ways we never imagined. It’s having an extra employee (or 10) for a fraction of the cost."
"The simplicity, flexibility and ability to build real complex automations without any knowledge of programming makes it the best thing since sliced bread."
"True citizen development in the entire company. Make is present in every department, empowering the company to offer a unique customer experience."