Google spreadsheets account redirect_uri?
Apparently we need to know the redirect_uri for setting up a google Outh account for reading a client’s google sheets. I have been unable to locate that information in the docs (or the community). The closest reasonable value I can find is for a different purpose: “https://elastic.snaplogic.com/api/1/rest/admin/oauth2callback/rest” Am I close to the target? Thanks, TK
Lead added/updated in Marketo creates record in Google Sheets
Created by @mthammareddy This pattern creates a lead in Marketo, then SnapLogic adds the lead into Google Sheets as a new row. Configuration You will need to define the following pipeline parameters: authorization, in the form of Bearer xxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx:xx endpoint, in the form of https://xxx-xxx-xxx.mktorest.com GoogleSheetsName, the name of the Google Sheet to write to sheetName, the name of the individual worksheet to write to within that Google Sheet Then you need to pass the user details with the parameters first, last, email, title, company, and country. The initial Mapper contains data to create a user. You can either replace these values every time or define pipeline parameters to pass the values in. Sources: Mapper Targets: Marketo Lead, Google Sheet Snaps used: REST Post, Mapper, Worksheet Writer, JSON Generator, Copy, JSON Splitter, Sequence, Join Downloads Marketo_Lead_Created_Updated_GoogleSheets.slp (19.7 KB)
Record Box files to Google Sheets
Created by @skatpally A file is uploaded to Box, SnapLogic stores the metadata of the file into Google Sheets as a new row Configuration Create App to get the access_token. You can also do OAuth2.0 Authentication Sources: Box Targets: Google Sheets Snaps used: REST Get, CSV Parser, WorkSheet Writer Downloads Record_Box_files_to_Google_Sheets.slp (6.0 KB)Record new CSV file in Box to Google Sheets
Created by @skatpally SnapLogic moves a CSV file uploaded to Box into Google Sheets as a new row. Configuration Webhooks need to created by the Client Sources: CSV file in Box Targets: Google Sheet Snaps used: Box Read Snap, CSV Parser, WorkSheet Writer Downloads Record_new_CSV_file_in_Box_to_Google_Sheets.slp (5.0 KB)