←  See more Retool integrations
Sheets

Sheets

Sheets, meet Retool.

Retool makes it easy to build admin panels, dashboards, and utilities on top of your Sheets data.


Connecting Retool to Google Sheets takes just a few minutes, and lets you to build user interfaces quickly on top of the data in your spreadsheets. For example, you can pull in data from your Google sheet, then run an API request for each row. Or, you could populate a blank template model in Google Sheets with data from your database. Here's a blog post about more use cases for our Google Sheets integration.

Retool supports querying arbitrary Google Sheets, as well cloning individual sheets and appending rows to existing sheets. In the future, we'll also support writing back to individual cells.

Read the Retool + Google Sheets integration docs for more information.

Sheets

Supercharge your business operations with Retool and Sheets.


“Using Retool, we've built internal tools for our retail and merchandising teams quickly, while maintaining our speed on feature development for our shoppers.”

Eddy Kim headshot
Eddy Kim
Engineering Manager
Verishop

Apps you can build with Sheets and Retool


const newStage = Object.assign(job_stage_form.data, { Type: select1.value })
const new_job_stages = job_stages.value.concat(newStage)
job_stages.setValue(new_job_stages)
modal1.close()
select1.setValue(null)

const index = i; // variable which is the index of the button that triggered this
const newData = Array.from(job_stages.value);
newData.splice(i, 1)
job_stages.setValue(newData);

var rawData = getProductDetails.data
var prdStlCmpLst = new Array()
for (x in rawData)
if (rawData[x]["dim_date_shops_products.material_family"] == select19.value)
prdStlCmpLst.push(rawData[x]["dim_date_shops_products.taxonomy_style"])
return prdStlCmpLst
SELECT
nps.'Product Feedback',
nps.nps_count as NPS,
feedbacks.feedback_count as Feedback,
sfdc.sfdc_count as Salesforce,
sfdc.opp_dollars as Opportunity_Dollars
from
{{npsTableCounts.data}} as nps
join {{feedbackTableCounts.data}} as feedbacks on nps.'Product Feedback' = feedbacks.FeedbackID
join {{sfdcTableCounts.data}} as sfdc on sfdc.FeedbackID = nps.'Product Feedback'
where
(
{{ multiselect2.value.length === 0 }}
OR nps.'Product Feedback' = ANY({{ multiselect2.value }})
)
     

In Retool, you can join Sheets data with anything.

Retool connects to most databases and nearly anything with a REST or GraphQL API. Read in data from mongoDB, join it via SQL, record user approvals, and POST the result to Stripe to create invoices. Retool empowers you to work with all of your data sources inside of a single app.