Google Sheets and Serper

Google Sheets

Triggers

• Google Sheets New RowTriggers when a new row is added to a Google Sheets spreadsheet.

Actions

• Append rowAppend a single row to the end of a Google Sheet.
• Create spreadsheetCreate a new Google Sheets spreadsheet.
• Delete spreadsheetDelete a Google Sheets spreadsheet permanently.
• Write rowOverwrite a whole row, from column A, with values in column order. To change only some cells of a row, use Update row.
• Update rowSet some cells of one row by column name, leaving the rest of the row as it is. Pair it with Read rows to write a result back to the row it came from. A column that doesn't exist yet is added to the header row.
• Clear row valuesClear values in a specific row without deleting the row itself.

Serper

Actions

• Search GoogleRun a Google search and get the organic results back as data, along with the knowledge panel, answer box, 'People also ask' questions, and related searches when Google shows them.
• Search Google ImagesSearch Google Images and get each picture's full-size and thumbnail address, its dimensions, and the page it came from.
• Search Google NewsSearch Google News and get the matching articles with their headline, publisher, publication date, and link.
• Search Google VideosSearch Google Videos and get the matching videos with their title, channel, length, and link.
• Search Google Maps placesFind local businesses and places on Google Maps, with their address, category, phone number, website, rating, and coordinates. Say where in words, such as a city; to search around a point on the map, use 'Search Google Maps around a point'.
• Search Google Maps around a pointSearch Google Maps around a point you choose, the way you would by moving the map and typing, and get each place's address, categories, phone number, website, rating, coordinates, and Place ID. Costs 3 Serper credits.