Activity
Mon
Wed
Fri
Sun
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Apr
What is this?
Less
More
Memberships
AI Automation Society
351.1k members • Free
1 contribution to AI Automation Society
Dec '24 •
Don't send info twice
I am getting information from an API search. I want to make sure I do not send the info twice so I have a Google sheet where I have the information I have already sent. I need to access the sheet check to see if it already exists, if so go to the next API info, if not add it to the sheet and send. I have been trying to do it with AI and the Google Sheet tool.
0 likes • Dec '24
Solved. Since I was doing this programmatically i.e. {{ $json.id }} I needed to use the ID and not the name, The ID for a Google sheet is not the normal ID an HTTP request will give you. The request needs to specify that you want a Google sheet ID!! I just stumbled across it by looking at the link to the page manually.
1-1 of 1
@william-brenza-1017
Owner of Realty Watchers, where we automate real estate tasks. I retired from Exxon Mobil's business IT group.
Active 205d ago
Joined Nov 10, 2024
Powered by