0CodeKit + Google Sheets
Trigger python code in 0CodeKit for new or updated rows in Google Sheets
With this workflow, whenever data in your Google Sheets changes, it sets off a sequence to execute your Python code via 0CodeKit. Ideal for those seeking to streamline their data science or programming roles, this process enhances productivity by cutting down on time-consuming manual interventions. It directly translates your updated spreadsheet information into a Python operation, granting real-time updates and more dynamic control over your programming projects.
With this workflow, whenever data in your Google Sheets changes, it sets off a sequence to execute your Python code via 0CodeKit. Ideal for those seeking to streamline their data science or programming roles, this process enhances productivity by cutting down on time-consuming manual interventions. It directly translates your updated spreadsheet information into a Python operation, granting real-time updates and more dynamic control over your programming projects.
- When this happens...
New or Updated Spreadsheet RowTriggered when a new row is added or modified in a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Run Python CodeRun Python code (.py) via the API.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNo Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundPython CodeRequired
WebhookRequired
Requirements
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DataRequired
Barcode Image FormatRequired
Width
Height
Barcode format
Font
Font Options
Text Align
Text Position
Text Margin
Line Color
Background color
Margin
Display Value
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.PDFRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.HeightRequired
WeightRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TextRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.First StringRequired
Second StringRequired
Algorithm
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TextRequired
KeywordRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.BufferRequired
Get As URL
File Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.URL
Buffer
File Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Input Field TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Destination URLRequired
Custom Identifier
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Message to encryptRequired
Secret KeyRequired
Crypto TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.No HeaderRequired
OutputRequired
DelimiterRequired
CSVRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Bin IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Start dateRequired
DurationRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Image UrlRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Image UrlRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.File IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Text to analyseRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TextRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.URLRequired
AxisRequired
Return As URL
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Hue
Luminosity
Count
Seed
Format
Alpha
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Week Number
Year
Unix Timestamp
Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Variable NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.URLRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.PDFRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Hint
YearRequired
Country CodeRequired
State
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.HTML CodeRequired
Scale
Landscape
Print Background Images
Format
Width
Height
Top Margin
Bottom Margin
Left Margin
Right Margin
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TokenRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Text to analyseRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
List All Saved Files
List all the saved files
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Country CodeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.AmountRequired
Generate Email
Generate Username
Generate Avatar
Generate a Password
Generate Birthday Date
Generate Address
Generate Phone Number
Generate User Creation Date
Generate Account Balance
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.URLRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Image URLRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Front Image URLRequired
Back Image URLRequired
Return As UrlRequired
PositionRequired
Vertical Position
Horizontal Position
Opacity
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Pdf URLRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Python CodeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Gender
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TypeRequired
LengthRequired
Custom characters
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Link to the image
Image buffer
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Retrieve Credits
Retrieve User Credits
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Code IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.URLRequired
Sigma
Return As URLRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Starting WordRequired
End wordRequired
TextRequired
Greedy
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TextRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Target LanguageRequired
TextRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Shortened URL IdentifierRequired
New Destination URLRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Upload Temporary File
Upload a temporary file
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email AddressRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Help
Help
VAT Identifier
Country Code
ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DomainRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DateRequired
Optional custom date format
Optional Time Zone
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Bin IDRequired
Input Field TypeRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Headers
Overwrite existing worksheets
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Text Bold
Text Italic
Text Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
Row Count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row CountRequired
First Row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Headers
Overwrite existing worksheets
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundHelp
ExternalRequired
KeyRequired
JSONRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Url of the barcodeRequired
Barcode typeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DataRequired
LabelsRequired
Get As Url
Width
Height
Background Color
Title
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.URLRequired
SigmaRequired
Return As URL
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Starting PointRequired
End PointRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Check User Execution Status
Check How Many Executions Left in Users Account.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.URLRequired
Get As URLRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.AmountRequired
Source CurrencyRequired
Target CurrencyRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.URLRequired
Output FormatRequired
Return As URL
Quality
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Variable NameRequired
ValueRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DataRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Cipher textRequired
Secret KeyRequired
Crypto TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Skip First RowRequired
DelimiterRequired
CSVRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Variable IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Shortened URL IdentifierRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Image UrlRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Image UrlRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.LabelsRequired
DataRequired
Get As Url
Width
Height
Background Color
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email SubjectRequired
Email BodyRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Short URLRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.UrlRequired
Get As Url
File Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.First NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.PromptRequired
QuantityRequired
SizeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.URLRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Website URL
HTML as string
ELement Tag
Class
ID
Multiple results?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Get Current Month
Get current month
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.MessageRequired
Secret KeyRequired
Hash TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.URL
HTML Code
Get As UrlRequired
Image type
Emulate Device
Disable Animations
Full-page
Dark Mode
Height
Width
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IP AddressRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Javascript CodeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DataRequired
Signature
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DataRequired
LabelsRequired
Get As Url
Width
Height
Background Color
Title
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.List All Global Variables
Get all the stored global variables
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.File UrlsRequired
PagesRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Text to analyse