Add your Foursquare check-ins (w/ maps) to a spreadsheet
Start today
Other popular Google Sheets workflows and automations
2.9k- Create a spreadsheet of new laws, eliminating the need for countless Washington, DC interns
1.1k - Log how much time you spend at specific locations like the office or home in a spreadsheet
155.7k - Log People ringing door bell
1.2k - Track watering in a Google spreadsheet
2.1k - Track every time the ISS passes over your house4.1k
- Save your Misfit sleep logs to a Google Spreadsheet
1.6k - Save the Tweets you like on Twitter to a Google Spreadsheet
2.5k - Log your Facebook status updates in Google Drive spreadsheet
1.3k
Useful Google Sheets and OneDrive integrations
Triggers (If this)
New file in folderThis Trigger fires every time a new file is created in the folder you specify.- New spreadsheet added to folderThis trigger fires when a new spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.
- New photo in folderThis Trigger fires every time a new photo is created in the folder you specify.
- New worksheet in spreadsheetThis trigger fires when a new worksheet is added to a spreadsheet you specify.
- New tagged photo in folderThis Trigger fires every time a new photo with the tag you specify is created in the folder you specify.
- New row added to spreadsheetThis trigger fires when a new row is added to a spreadsheet you specify.
- New file matching regex in folderThis trigger fires every time a new file whose filename matches the regular expression you specify is added to the folder you specify
- Cell updated in spreadsheetThis trigger fires when a particular cell is updated within the spreadsheet you specify.
- New file matching search in folderThis trigger fires every time a new file whose filename or file contents contains the words you specify is added to the folder you specify
- New file or folder shared with meThis trigger fires every time a new file or folder is shared with you
Queries (With)
- History of files uploaded in folderThis query returns a list of recent files created in the folder you specify.
- Current values of a rowThis query returns the current values in a given row. Values from columns A-Z are available as ingredients.
- History of file matching search uploaded in folderThis query returns a list of recent files whose filename or file contents contains the words you specify is added to the folder you specify
- Current value of a cellThis query returns the current value of a single cell in your spreadsheet.
- History of files or folders shared with meThis query returns a list of recent files or folders shared with you
- History of rows added to spreadsheetThis query returns a list of when a new row is added to a spreadsheet you specify.
- History of photo uploaded in folderThis query returns a list of recent photos created in the folder you specify.
- History of when Cell was updated in spreadsheetThis query returns a list of when a particular cell was updated within the spreadsheet you specify.
- History of photos with a tag uploaded in folderThis query returns a list recent photos with the tag you specify is created in the folder you specify.
- History of spreadsheets added to folderThis query returns a list of when a new spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.
- History of file matching regex uploaded in folderThis query returns a list recent files whose filename matches the regular expression you specify is added to the folder you specify
- History of worksheets in spreadsheetThis query returns a list of when a new worksheet is added to a spreadsheet you specify.
Actions (Then that)
- Create text fileThis action will create a new text file at the path you specify
- Add row to spreadsheetThis action will add a single row to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.
- Append to a text fileThis Action will append to a text file as defined by the file name and folder path you specify
- Update cell in spreadsheetThis action will update a single cell in the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created if the file doesn't exist.
- Add file from URLThis Action will download a file at a given URL and add it to OneDrive at the path you specify. NOTE: 30 MB file size limit.
Google Sheets and OneDrive resources
How to export Google Contacts
Click to learn how to export Google Contacts - Automate your Gopogle Contacts
Top 3 cheapest cloud storage options
Click to learn about the top 3 cheapest cloud storage options!
5 best cloud storage apps to access docs easily
Find the best cloud storage apps for accessing your content easily and learn how IFTTT can help you integrate your cloud storage with other tools you love.
IFTTT helps all your apps and devices work better together