Google Sheets + Schedule by Zapier + Jibble
Add Jibble timesheets to Google Sheets rows every week
At the day and time of your choice every week, this integration will add a Jibble timesheet summary to a Google Sheets row automatically.
At the day and time of your choice every week, this integration will add a Jibble timesheet summary to a Google Sheets row automatically.
- When this happens...
Every WeekTriggers every week, on the day(s) selected.
TriggerInstantThis event starts a Zap instantly. - automatically do this...
Find Timesheets SummaryFinds Timesheets Summary.
ActionSearchFind existing data in your app - then do this!
Create Spreadsheet RowCreate a new row in a specific spreadsheet.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Frequency TypeRequired
Interval
Start DateRequired
Time of DayRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Time Offset
Trigger on weekends?
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Day of the WeekRequired
Time of DayRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New Activity
Triggers when a new activity is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Clock-In
Triggers when someone clocks-in.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Location
Triggers when a new location is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Project
Triggers when a new project is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew or Update Client
Triggers when a new client is created or updated.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew or Update Manual Time Entry
Triggered when manual time entry is added for member
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew or Update Person
Triggers when a new member is added or updated.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew or Update Activity
Triggers when an activity is created or updated.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planPersonRequired
Activity
Project
Note
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Description
Code
Color
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Schedule
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Person IdRequired
DateRequired
HoursRequired
MinutesRequired
Activity Id
Project Id
Note
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Code
Description
Client
Location
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ActivityRequired
Archive Activity
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.GroupRequired
Name
Schedule
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project IDRequired
Archive Project
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Client NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appGroup IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appLocation IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appPerson IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appStart DateRequired
End DateRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNameRequired
Description
Code
Color
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNameRequired
Schedule
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNameRequired
AddressRequired
GeoFence radius
GeoFence radius units
Coordinates latitude
Coordinates longitude
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundEmailRequired
Full NameRequired
Phone Number
Group
Schedule
Code
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNameRequired
Code
Description
Client
Location
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNo 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 found
Time of DayRequired
Trigger on weekends?
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Day of the MonthRequired
Time of DayRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Clock-Out
Triggers when someone clocks-out.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Client
Triggers when a new client is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Group
Triggers when a new group is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Person
Triggers when a new member is added.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew TimeEntry Record
Triggers when someone clocks-in, clocks-out or go on break.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew or Update Group
Triggers when a new group is created or updated.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew or Update Location
Triggers when a new location is created or updated.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planGo on Break
Triggers when someone is on break.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew or Update Project
Triggers when a project is created or updated.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planPersonRequired
Note for Clock out
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
AddressRequired
GeoFence radius
GeoFence radius units
Coordinates latitude
Coordinates longitude
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Full NameRequired
Email
Phone Number
Group
Schedule
Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.New Member EmailRequired
New Member Full NameRequired
code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ClientRequired
Name
Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.LocationRequired
Name
Address
GeoFence radius
GeoFence units
Coordinates latitude
Coordinates longitude
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Activity NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appGroup NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appLocation NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appPerson emailRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProject NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appPeriodRequired
Start DateRequired
Person
ActionThis is an event a Zap performs.SearchFind existing data in your appNameRequired
Code
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundGroup IdRequired
NameRequired
Schedule
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundLocation IdRequired
NameRequired
AddressRequired
GeoFence radius
GeoFence radius units
Coordinates latitude
Coordinates longitude
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundPerson IdRequired
Full NameRequired
Email
Phone Number
Group
Schedule
Code
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDrive
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 found
About Google Sheets
Related categories
About Schedule by Zapier
Related categories