python comes to google sheets

[{"selector":"#anim-931b8f5f-00c5-48b0-bc81-d6a959b943a7","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-853a14a4-3c4f-408f-a6b9-4e8c1bfe81dd","keyframes":{"opacity":[0,1]},"delay":150,"duration":1001,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ee5f2fb6-c549-4ba1-a230-17d8293eb716","keyframes":{"transform":["translate3d(0px, 251.32853%, 0)","translate3d(0px, 0px, 0)"]},"delay":150,"duration":1001,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}]

In a move that should please data analysts and programmers alike, Google has announced

[{"selector":"#anim-57550cfb-9ac4-42ab-a473-0f58eeb58f18","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-217c38d4-06b8-4dd8-a53c-af618056f702","keyframes":{"opacity":[0,1]},"delay":150,"duration":1001,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-1541de41-2e7d-416a-ac94-f4ec2b9d049f","keyframes":{"transform":["translate3d(0px, 152.66791%, 0)","translate3d(0px, 0px, 0)"]},"delay":150,"duration":1001,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}]

Users will be able to write Python scripts directly in Google Sheets

[{"selector":"#anim-64dcade7-73ce-4cbd-9aa7-a244f60e2989","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f9b12a1d-0912-4759-950f-cbdff3fb80ff","keyframes":{"opacity":[0,1]},"delay":150,"duration":1001,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-fa08b285-aeb7-40ab-98c7-d56110a6e169","keyframes":{"transform":["translate3d(0px, 166.15832%, 0)","translate3d(0px, 0px, 0)"]},"delay":150,"duration":1001,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}]

use them to automate tasks

[{"selector":"#anim-1efd98db-4857-4eed-a02c-0d56040d5f9c","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-2190c6be-c9da-47e9-8ac8-309bc506cdfe","keyframes":{"opacity":[0,1]},"delay":150,"duration":1001,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-7687981d-fc2b-4263-8345-3bd54c9fa25c","keyframes":{"transform":["translate3d(0px, 223.00196%, 0)","translate3d(0px, 0px, 0)"]},"delay":150,"duration":1001,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}]

Will be able to perform complex calculations and create custom visualizations

[{"selector":"#anim-97aa5f23-65b1-4b79-9cc7-956b6021bc96","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-b1609b63-7f20-4fa2-a8c6-a8fe2124cc4e","keyframes":{"opacity":[0,1]},"delay":150,"duration":1001,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-04bb30f2-a5bd-4c8d-86ce-309b2f34e2a1","keyframes":{"transform":["translate3d(0px, 129.64883%, 0)","translate3d(0px, 0px, 0)"]},"delay":150,"duration":1001,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}]

The integration of Python with Google Sheets is being made possible by the Google Sheets API.

[{"selector":"#anim-c682d732-0754-457c-9d14-a8950587c61c","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-efab20bb-ad40-495c-9ccf-b20f67b44cd2","keyframes":{"opacity":[0,1]},"delay":150,"duration":1001,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-4697ab43-857e-496d-ad46-4fecd3b5cf86","keyframes":{"transform":["translate3d(0px, 129.64883%, 0)","translate3d(0px, 0px, 0)"]},"delay":150,"duration":1001,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}]

API allows developers to create and interact with Google Sheets programmatically

[{"selector":"#anim-86502f60-a9fa-4618-8a95-57ac6a77719e","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-d9182db8-a3d0-4e49-bd63-debafa500c26","keyframes":{"opacity":[0,1]},"delay":150,"duration":1001,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-d18480f1-1ea9-429a-887d-e377f1afa5c1","keyframes":{"transform":["translate3d(0px, 129.64883%, 0)","translate3d(0px, 0px, 0)"]},"delay":150,"duration":1001,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}]

By making the API available to Python developers, Google is opening the door to a wide range of new possibilities for Google Sheets.

[{"selector":"#anim-ec4186d3-a4a1-4b9f-bbdc-e69c759c7f1f","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-01d16a74-9795-4d23-bd40-b85f6e26713c","keyframes":{"opacity":[0,1]},"delay":150,"duration":1001,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-b69c88cc-aedd-4e8b-947e-7144647d3c7d","keyframes":{"transform":["translate3d(0px, 130.68511%, 0)","translate3d(0px, 0px, 0)"]},"delay":150,"duration":1001,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}]

Some potential benefits of using Python with Google Sheets include

[{"selector":"#anim-dbc2b4af-cb4d-41dd-8a0c-118942912f16","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-52aec758-9336-4932-b40a-a7345f7107b7","keyframes":{"opacity":[0,1]},"delay":150,"duration":1001,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ff938c47-9c1e-41d3-a66f-1415f5a12d89","keyframes":{"transform":["translate3d(0px, 166.15832%, 0)","translate3d(0px, 0px, 0)"]},"delay":150,"duration":1001,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}]

Python can be used to automate a wide range of tasks in Google Sheets such as data cleaning, data formatting, and data analysis

[{"selector":"#anim-0264d5fb-4d35-4c06-86fa-2c48a3fd8eb0","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-af92cb2a-df7d-4767-aebf-ec5d64a55552","keyframes":{"opacity":[0,1]},"delay":150,"duration":1001,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-7af7fe01-f830-4163-9144-7f12e6b75a3f","keyframes":{"transform":["translate3d(0px, 130.16698%, 0)","translate3d(0px, 0px, 0)"]},"delay":150,"duration":1001,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}]

Python can be used to perform complex calculations

[{"selector":"#anim-0935cf07-1cc3-4634-957b-07962ffaebf0","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-90e3f297-80e9-4121-8605-0a3fee27d4b3","keyframes":{"opacity":[0,1]},"delay":150,"duration":1001,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-8d4abe4c-32b2-489b-a56b-cc7d05f3fb87","keyframes":{"transform":["translate3d(0px, 155.40015%, 0)","translate3d(0px, 0px, 0)"]},"delay":150,"duration":1001,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}]

Those that would be difficult or impossible to do in Google Sheets alone

[{"selector":"#anim-77c7063f-233b-49fe-97cf-1b5d9ce27760","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-e680f5b3-5998-4381-b062-ab2499d788c8","keyframes":{"opacity":[0,1]},"delay":150,"duration":1001,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-59658f54-b391-4c79-a862-ce3d81f52779","keyframes":{"transform":["translate3d(0px, 165.19035%, 0)","translate3d(0px, 0px, 0)"]},"delay":150,"duration":1001,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}]

Custom Visualizations: Python can be used to create custom visualizations

[{"selector":"#anim-8c5424c9-25eb-4bcb-893c-ace5e2956bb8","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-bf76d9ae-d783-4678-b968-31892c24b4d5","keyframes":{"opacity":[0,1]},"delay":150,"duration":1001,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-649eb9a7-b60c-4845-a483-92ef2c6dfe3b","keyframes":{"transform":["translate3d(0px, 160.27597%, 0)","translate3d(0px, 0px, 0)"]},"delay":150,"duration":1001,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}]

Python integration with Google Sheets is an important development

[{"selector":"#anim-e003d198-2a43-442f-a305-56d80e8cd16e","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-3afe22bb-44f1-49b4-b143-0e00be3fa3b2","keyframes":{"opacity":[0,1]},"delay":150,"duration":1001,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-0fde861a-0d54-4d7d-b35c-66808dd90968","keyframes":{"transform":["translate3d(0px, 138.70736%, 0)","translate3d(0px, 0px, 0)"]},"delay":150,"duration":1001,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}]

The arrival of Python in Google Sheets is a major development that will make the platform even more powerful and versatile.

[{"selector":"#anim-5909756c-2c88-47c8-94c7-900d66a36e86","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-4c97df53-79f0-432e-bd7c-b6dce3c650c1","keyframes":{"opacity":[0,1]},"delay":150,"duration":1001,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-31b19db5-a908-49ac-b5c6-2398e255abf6","keyframes":{"transform":["translate3d(0px, 152.10295%, 0)","translate3d(0px, 0px, 0)"]},"delay":150,"duration":1001,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}]

Remini enhancing your photo

[{"selector":"#anim-5fb742cf-fe14-4a5b-a0be-529088b5c764","keyframes":{"transform":["scale(1)","scale(1.5)","scale(0.95)","scale(1)"],"offset":[0,0.33,0.66,1]},"delay":0,"duration":1450,"easing":"ease-in-out","fill":"both","iterations":1}] Learn more