Why am I Receiving an Error when Trying to Store the Main and Sub-Folder in Google Sheets Using the Google Sheet Update Component?

Help
1

This topic was automatically generated from Slack. You can find the original thread here.

The trigger is using GOOGLE SHEETS - ADDED ROW

Then based on data, we run CREATE MAIN FOLDER. Then we SET PERMISSION. Then we create a sub folder in the main folder. Then we want to store the main folder and sub-folder in the GOOGLE SHEET using the GOOGLE SHEET UPDATE COMPONENT.

Here is the error I am getting:

No matching variables in scope (search:{ "MAIN FOLDER ID": "{{steps.create_main_folder.$return_value.id}}", "GOOGLE DRIVE LOCATION": "_", "GOOGLE DRIVE CREATED": "_", "GOOGLE DRIVE FOLDER ID": "{{steps.create_sub_folder.$return_value.id}}", "COMPLETE": "1" })
2

Based on the error message you provided, it seems that the variables steps.create_main_folder.$return_value.id and steps.create_sub_folder.$return_value.id are not found in the scope. This could be due to a few reasons: 1. The steps create_main_folder and create_sub_folder are not correctly defined or executed before this step. Please ensure these steps exist and are executed successfully before this step. 2. The return values id from the steps create_main_folder and create_sub_folder are not available. Please check the return values of these steps to ensure they contain the id field. 3. There might be a typo in the variable names. Please double-check the spelling and case-sensitivity of your variable names. If you’re still having trouble, could you please provide more details about your workflow, especially the create_main_folder and create_sub_folder steps? This will help me assist you better.

3

I did an experiment. Instead of passing returned values, I hardcoded the values and it still gave me an error.

{
	"MAIN FOLDER ID": "1tna8wibBVYT6364hJe0_AgnBcDSsJO3p",
	"GOOGLE DRIVE LOCATION": "_",
	"GOOGLE DRIVE CREATED": "_",
	"GOOGLE DRIVE FOLDER ID": "1B07GafbTt4GVcWPG1NzasezJqYAMvADo",
	"COMPLETE": "1"
}

Here is the return value in the components.
steps.update_row{1}
$return_value{5}
spreadsheetId:
1TvmzUnWL3BJ4DRdaIbdGC7TjksbiKqe448IMXpR5RXM
updatedRange:
'CHATGPT STORY LOG'!A73
updatedRows:
1
updatedColumns:
1
updatedCells:
1

{"spreadsheetId":"1TvmzUnWL3BJ4DRdaIbdGC7TjksbiKqe448IMXpR5RXM","updatedRange":"'CHATGPT STORY LOG'!A73","updatedRows":1,"updatedColumns":1,"updatedCells":1}
4

the chat just stopped.

5

thanks, I’ll look into it

6

It appears that you are encountering an error when trying to update a Google Sheet with hardcoded values. The error message and the return values you’ve provided suggest that the update operation itself is being performed, as indicated by the updatedRange and other properties, but there might be an issue with how the update is being specified or with the data structure expected by the Google Sheets API. To assist you better, I would need to see the actual Pipedream code you’re using to perform the Google Sheets update operation. Specifically, I need to see the configuration of the axios request within the Pipedream component that is responsible for the update. This would include the method, URL, headers, and body of the request. If you could provide the relevant part of your Pipedream workflow code, especially the part that constructs the request to update the Google Sheet, I can help you debug the issue further.

7

It appears that you’re encountering an error when trying to update a Google Sheet with hardcoded values. The error message you’ve provided suggests that there might be an issue with the way the data is being passed to the Google Sheets Update component. To assist you further, I would need to see the actual Pipedream workflow configuration, specifically the step where you’re updating the Google Sheet. The error could be due to incorrect mapping of the fields, an issue with the Google Sheets Update component configuration, or a problem with the permissions set on the Google Sheet. Could you please provide the following information: 1. The configuration of the Google Sheets Update component in your Pipedream workflow, including how you’re mapping the fields to be updated. 2. Confirm that the Google Sheets API is enabled and that the Pipedream workflow has the necessary permissions to update the Google Sheet. 3. The exact step in your workflow where this error occurs, and any relevant logs that show the error message in context. With this information, I’ll be able to provide more targeted assistance to resolve the issue you’re facing.