Why Isn't My Google Sheet Updating Despite Successful API Workflow and Authentication?

Help
1

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

Hello! :slightly_smiling_face:
New user here, I have created a workflow to get data from an API, format it and put it into a google sheet, I have everything authenticated and get a success message from google sheets, but my sheet itself doesn’t update :thinking_face:

Any help is appreciated!

Screenshot 2024-08-09 at 11.52.13.png
Screenshot 2024-08-09 at 11.52.13.png1709×1167 226 KB

2

Hi , could you share the screenshot of your full Google Sheet Action configuration if possible?

3

Thanks :slightly_smiling_face: attaching now

Screenshot 2024-08-09 at 14.05.44.png
Screenshot 2024-08-09 at 14.05.44.png1709×1167 207 KB

Screenshot 2024-08-09 at 14.05.41.png
Screenshot 2024-08-09 at 14.05.41.png1709×1167 256 KB

4

Thanks , could you share the sample data of your csv_data?

Also, could check the Input tab highlighted in the image below?

IMG_1463.jpg
IMG_1463.jpg1709×1167 114 KB

5

Sure - I made a simple test to see if there was an issue with my data format being transformed:
also attaching input tab:

Screenshot 2024-08-09 at 15.13.15.png
Screenshot 2024-08-09 at 15.13.15.png1363×804 107 KB

Screenshot 2024-08-09 at 15.13.51.png
Screenshot 2024-08-09 at 15.13.51.png1293×711 92.7 KB

6

Hi , I think the Row Values prop in your Google Sheet action is incorrect. You’re referring the undefined data.

Based on your Save_StatsDrone_Data step, it should be {{steps.Save_StatsDrone_Data.$return_value.rows_data}} (notice that it should be rows_data , not csv_data)

7

:100:, thanks that was it!