Adding chat history to Claude prompt

I’m building a scenario where a text is processed through a series of Claude prompts. I’ve set up a data store to save each prompt and its corresponding output. However, I’m unsure of the best way to include this conversation history in the subsequent prompts.

If I add the data store at the beginning of the new prompt message, it becomes too long (we’re working with an entire ebook chapter at a time), and Claude doesn’t process the new instructions well. Is there a better place within the Claude module to attach or reference this conversation history without overwhelming the input field?

I’d recommend you use a real database like airtable or Google sheets to store the chatgpt prompts and their outputs

Ok. If I use a Google sheets, what’s the best way to have a Claude module read that historical chat information without distracting it from the new prompt?